Forum Discussion

RenataOGardner's avatar
RenataOGardner
Icon for Helper II rankHelper II
5 years ago
Solved

Top 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.  
Jos_Woolley's avatar
Jos_Woolley
Icon for Solution Sage rankSolution Sage
5 years ago

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's avatar
    RenataOGardner
    Icon for Helper II rankHelper II
    5 years ago

    Thanks for Jos.

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