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. 

 

Model/Description

Code

Quantity

eStudio3540cse

MFP-2

0

eStudio3540cse

MFP-2

0

eStudio3550cse

MFP-2

1

eStudio3500se

MFP-2

1

 

I'm trying to create a new measure for Quantity column but it doesn't work. 

Count MFP = CALCULATE(COUNTA('Printer'[Qty]),'Printer'[Qty]="1"

 

Expected result of the KPI card should counts only printer with the "1" number.

 

Thanks for your time.

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

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Zaky ,

     

    Use this formula

     

    CountQuantity = CALCULATE(COUNTA(Table1[Model/Description]),FILTER(Table1,Table1[Quantity]="1"))

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Zaky's avatar
      Zaky
      Helper IV
      7 years ago

      Hi,

       

      I'm trying created the measure, but it's not working.

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      However, to eliminate the Zero counts you will need to use the Visualizations Visual Level Filter to eliminate Zero.