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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

One way is to create another table:

 

AAA

BBB

CCC

 

Create a relationship between the tables. Then, in this new table, create a column like so:

 

Column = 1 / COUNTROWS(RELATEDTABLE('Cases'))

Create a matrix with ID, Case ID and EMP NAME and this column.