Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |