How to summarize a measure?

[Anonymous]

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 Points	Number of Travelers
Over 183 Days	0
151 - 183 Days	0
91 - 150 Days
61 - 90 Days	4
31 - 60 Days	49
1 - 30 Days	1839

Is this possible in Power BI?

[v-piga-msft]

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]

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]

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