Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to summarize a measure?

Hi Everyone!   I have a proble which drives me mad... hope you will be able to help.   I've created a measure that returns 6 categories (Trigger Points), I would like to create a table (KPI) that...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

 

You could try with SUMMARIZE fucntion to create a calculated table.

 

If you still need help, please share some data sample which could reproduce your scenario so that we could help further on it.

 

Best  Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for the suggestion!

     

    Now I need to change "Over 183 Days" into a variable that will help to reffer to a table that has all 6 categories but no relationshipt to the fact table.

     

    • v-piga-msft's avatar
      v-piga-msft
      Icon for Resident Rockstar rankResident Rockstar
      7 years ago

      Hi Anonymous ,

       

      I still have a little confused about your requirement.

       

      If it is convenient, could you share a dummy pbix file which can reproduce the scenario. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)

       

      To understand your requirement better, please share your desired output so that we could help further on it.

       

      Best  Regards,

      Cherry