COUNT CALCULATED MEASURE

[johmedrano]

Hello,

I have a calculated measure called Final Status that is based on different criteria from my Sales Table.

I would need to count the number of rows for each of the final Status measures: NEW, LAPSED, EXISTING

Could you possibly help me ?

Thanks a lot,

[Zubair_Muhammad · Accepted solution]

HI @johmedrano

Try this Calculated Table

From the Modelling Tab>>New Table

New Table =
SUMMARIZE (
    SUMMARIZE ( TableName, TableName[PartnerName], "MyMeasure", [Final Status] ),
    [Final Status],
    "MyCount", COUNT ( TableName[PartnerName] )
)

[johmedrano]

It works. Thanks a lot.