Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Custom Matrix for displaying data as cohort visualization

Dear all, I am having a table on Power BI having the structure like this:   I want to use matrix and custom it to receive the desired output like this one (it can be understood as cohort vis...
Need Help
  • Priya1969's avatar
    Priya1969
    3 years ago

    Thanks!   Once you added, 'Week' and 'Total members' in the row,

    1. Select the format pane, expand the row headers, off the stepped layout.

    2. On the top, select Data/Drill option, then click the expand next level button.

    You will get the desire output.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

You can use the ISINSCOPE function to specifically return the value of Subtotal.

ISINSCOPE function (DAX) - DAX | Microsoft Learn

For example, 1 can put Chosen Member in it, and 0 can put Total Member in it.

Measure = IF(ISINSCOPE('Table'[Year]),1,0)

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for your suggestions. But the column "Members" does not reflect the subtotal of all the index value in that row. And one more thing to consider is that it does not need to be calculated, since it has already had values inside.