Search code examples
powerbidax

New Measure in Power BI which show count of raw_stnd_id for each raw_adm_appl_id where rn_desc = 1

I have a table as below, this below sample has only two raw_adm_appl_id, but the full table has many raw_adm_appl_id

Sample Table

I want to create a new measure using DAX which will count all the raw_stdnt_id's where rn_desc = 1 partitioned by raw_adm_appl_id. Means for each raw_adm_appl_id, it will take the row where the rn_desc = 1 and count total number of rows having run_desc = 1 over all the different raw_adm_appl_id's.

Solution

  • First write a measure

    Measure = CALCULATE(COUNT('Table'[raw_stdnt_id]), 'Table'[rn_desc] = 1)

    Then write summarize function to get desired result

    Table 2 = SUMMARIZE('Table', 'Table'[raw_adm_appl_id], "stdnt_count", [Measure])