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
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.

      • 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
  • 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.