Forum Discussion
Syndicate_Admin
1 year agoAdministrator
Duda with chart based on display table
Good morning I'm new to this forum and relatively also with PowerBI. I have some data in excel of this type that obeys a survey: I need to create a report with a filter by country, a table, ...
- Anonymous1 year ago
Hi, Syndicate_Admin
Based on your information, I create a sample table:
You can create a new measure, try the following dax expression:
MaxScorePerDistrictMeasure = CALCULATE( MIN('Table'[PUNTOS]), ALLEXCEPT('Table', 'Table'[Country], 'Table'[City], 'Table'[District]) )Then create visuals and put fields in them, here is my preview:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_Admin
1 year agoAdministrator
Thank you for the help, it helped me to solve it!