Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Rolling Up Dynamic Data

 

Hello, I need to use custom measures to make the chart on the left appear as the chart on the right. The data has to be dynamic. How can I go about rolling this up? Thanks

 

 

 

 

  • HI Anonymous 

     

    Download sample PBIX file

     

    You need to have a category for each item in order to do this.  No need to write measures.

     

     

    The data can then be summarized in a table like this

     

     

     

    Regards

     

    Phil

1 Reply

  • HI Anonymous 

     

    Download sample PBIX file

     

    You need to have a category for each item in order to do this.  No need to write measures.

     

     

    The data can then be summarized in a table like this

     

     

     

    Regards

     

    Phil