cancel
Showing results for
Did you mean: Helper IV

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

2 ACCEPTED SOLUTIONS Community Support

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.

Frequent Visitor

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 7 Resolver IV

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

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

Hi,

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

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

Yes..  got it!.  The formula is working as per what i expected.

Thank you so much !

Regards,

ZAKY

Frequent Visitor

Hi,

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

Count = CALCULATE(COUNT(Sheet2[code]),Sheet2[quantity] = 1)

Thanks,
Surya teja Helper IV

This formula also works accordingly 🙂

Thanks for help.  