cancel
Showing results for
Did you mean:
Member

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

Accepted Solutions
Community Support Team

## Re: Need Help with a Measure Formula

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

## Re: Need Help with a Measure Formula

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
Member

## Re: Need Help with a Measure Formula

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.

Highlighted
Member

## Re: Need Help with a Measure Formula

Hi,

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

Community Support Team

## Re: Need Help with a Measure Formula

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

## Re: Need Help with a Measure Formula

Hi,

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

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

Thanks,
Surya teja
Member

## Re: Need Help with a Measure Formula

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

Member

## Re: Need Help with a Measure Formula

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

Thank you so much !

Regards,

ZAKY

Member

## Re: Need Help with a Measure Formula

This formula also works accordingly :-)

Thanks for help.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 207 members 2,286 guests
Recent signins: