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        
  • PhilipTreacy's avatar
    4 years ago

    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