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.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.