Forum Discussion

Zaky's avatar
Zaky
Helper IV
7 years ago
Solved

Need Help with a Measure Formula

Hi All, Wondering if someone would able to help me with a correct formula to count column Quantity as per table below.  I would like to show quantity of each printer model i KPI card.    Mode...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Zaky 

    Create a measure

    Measure = CALCULATE(COUNTA(Table1[Model/Description]),FILTER(ALL(Table1),Table1[Quantity]=1))

     

    Best Regards
    Maggie

     

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

  • suryaburaboyina's avatar
    suryaburaboyina
    7 years ago

    Hi,

     

    can you please try below measure and mark correct if it works.

     

    Count = CALCULATE(COUNT(Sheet2[code]),Sheet2[quantity] = 1)
     
    Thanks,
    Surya teja
suryaburaboyina's avatar
suryaburaboyina
Frequent Visitor
7 years ago

Hi,

 

can you please try below measure and mark correct if it works.

 

Count = CALCULATE(COUNT(Sheet2[code]),Sheet2[quantity] = 1)
 
Thanks,
Surya teja
Zaky's avatar
Zaky
Helper IV
7 years ago

suryaburaboyina 

This formula also works accordingly :-)

 

 

Thanks for help.