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.
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.
Go to Solution.
Create a measure
Measure = CALCULATE(COUNTA(Table1[Model/Description]),FILTER(ALL(Table1),Table1[Quantity]=1))
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
can you please try below measure and mark correct if it works.
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.
I'm trying created the measure, but it's not working.
However, to eliminate the Zero counts you will need to use the Visualizations Visual Level Filter to eliminate Zero.
Yes.. got it!. The formula is working as per what i expected.
Thank you so much !
This formula also works accordingly :-)
Thanks for help.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!