Forum Discussion

Andregewehr's avatar
Andregewehr
Helper I
4 years ago
Solved

Count a Measure in a ABC Classification

Hi people!   I have the following table with 10 products for 2 stores and I have a [ABC] measure (I filter by date, store, product): STORE PRODUCT [ABC] Store 1 1 A Store 2 2 B S...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Andregewehr ;

    Create measure as follow:

    A = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="A")
    B = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="B")
    C = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="C")

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Andregewehr ;

Create measure as follow:

A = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="A")
B = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="B")
C = CALCULATE(COUNT('Table'[[ABC]]]),'Table'[[ABC]]]="C")

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.