Top accounts

[RenataOGardner]

Hello,
Could you please help me with a measure where I can see the number of locations with more than 10 total cases in either South America or North America? Thanks a lot in advance.

[Greg_Deckler · Accepted solution]

@RenataOGardner Easiest way would be to just use the Filter pane to filter TotalCases > 10. Otherwise, you could always use a Complex Selector. The Complex Selector - Microsoft Power BI Community

[Jos_Woolley]

Hi,

Assuming a table named 'Cases' with columns 'Continent', 'Country' and 'Total Cases', this measure:

Locations (> 10 Cases North or South America) =
CALCULATE (
    COUNTROWS ( 'Cases' ),
    'Cases'[Continent] IN { "North America", "South America" },
    'Cases'[Total Cases] > 10
)

Regards

[RenataOGardner · Accepted solution]

Thanks for Jos.

What to do, if the continent is on another table please?

[Greg_Deckler · Accepted solution]

@RenataOGardner Easiest way would be to just use the Filter pane to filter TotalCases > 10. Otherwise, you could always use a Complex Selector. The Complex Selector - Microsoft Power BI Community

[RenataOGardner]

Thank you so much. The filter panel worked fine.