Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
Thanks for Jos.
What to do, if the continent is on another table please?
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
Thanks for Jos.
What to do, if the continent is on another table please?
@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
Thank you so much. The filter panel worked fine.
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
55 | |
28 | |
19 | |
14 |