Need Help with a Measure Formula

[Zaky]

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.

[v-juanli-msft · Accepted solution]

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]

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

[Anonymous]

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

[Zaky]

Hi,

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

[v-juanli-msft · Accepted solution]

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.

[Zaky]

@v-juanli-msft 

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

Thank you so much !

Regards,

ZAKY

[suryaburaboyina · Accepted solution]

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]

@suryaburaboyina 

This formula also works accordingly 🙂

Thanks for help.