Forum Discussion

powerbi_bi's avatar
powerbi_bi
Frequent Visitor
9 years ago
Solved

How to create breakdown using DAX

Hi, I have a table and using Power BI Desktop Im trying to display this data ID Case ID EMP NAME 1 AAA Joe 1 AAA Mark 2 BBB Joe 3 CCC David 3 CCC Joe 3 CCC Mark ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi powerbi_bi,

     

    In your scenario, you can create a Matrix visual, and place ID, Case ID, EMP NAME columns in Rows property. Then create a measure like below and place it in Values property:

     

    DIVIDE = COUNTROWS( Sheet1 ) / CALCULATE( COUNTROWS( Sheet1 ), ALLEXCEPT( Sheet1, Sheet1[Case ID] ) )

     

     

    If you have any question, please feel free to ask.

     

    Best Regards,

    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi powerbi_bi,

 

In your scenario, you can create a Matrix visual, and place ID, Case ID, EMP NAME columns in Rows property. Then create a measure like below and place it in Values property:

 

DIVIDE = COUNTROWS( Sheet1 ) / CALCULATE( COUNTROWS( Sheet1 ), ALLEXCEPT( Sheet1, Sheet1[Case ID] ) )

 

 

If you have any question, please feel free to ask.

 

Best Regards,

Qiuyun Yu

  • powerbi_bi's avatar
    powerbi_bi
    Frequent Visitor
    9 years ago

    Thanks Qiuyun_Yu

    Works like a charm!