Forum Discussion
Helper IITop accounts
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.
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
Thanks for Jos.
What to do, if the continent is on another table please?
4 Replies
- Jos_Woolley
Solution Sage
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
RenataOGardnerThanks for Jos.
What to do, if the continent is on another table please?
- Greg_Deckler
Community Champion
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.
