Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago
Solved

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, ...
  • Anonymous's avatar
    Anonymous
    1 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.

Anonymous's avatar
Anonymous
Not applicable
1 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.