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 would summarise this measure like the table shown below by simply giving me a count of each category.

 

Trigger PointsNumber of Travelers
Over 183 Days0
151 - 183 Days0
91 - 150 Days
61 - 90 Days4
31 - 60 Days49
1 - 30 Days1839

 

Is this possible in Power BI?

Need Help

3 Replies

  • 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