Forum Discussion

johmedrano's avatar
johmedrano
Frequent Visitor
8 years ago
Solved

COUNT CALCULATED MEASURE

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's avatar
    Zubair_Muhammad
    8 years ago

    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] )
)

     

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    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] )
)