Forum Discussion

jamuka's avatar
jamuka
Icon for Helper IV rankHelper IV
7 years ago
Solved

How to Calculate with Two Criteria

Hello,   I'm making an ABC analysis report and couldn't show total product number for each group in matrix visual. When I do it for total value of products, it shows correct numbers but for quantit...
Need Help
Show and Tell
Tips and Tricks
  • jamuka's avatar
    jamuka
    7 years ago

    Hi calerof,

     

    This if the first time I'm using power bi.

    I have several workbooks and I extract data from them via calculated column ( with lookupvalue) to my main table. Then I made some basic math calculations, still with calculated columns. There's no measure in my screenshots,  but when I tried to write the measure so I can post, I figured my mistake. 

    I didn't add "count" function to my measure, when I added it works.

     

    = CALCULATE(COUNT(Listing[Product]);Listing[Day]="Without Stock")
     
    thanks for your help
calerof's avatar
calerof
Icon for Impactful Individual rankImpactful Individual
7 years ago

Hi jamuka ,

 

And, where are your measures?

 

Cheers,

 

Fernando

 

jamuka's avatar
jamuka
Icon for Helper IV rankHelper IV
7 years ago

Hi calerof,

 

This if the first time I'm using power bi.

I have several workbooks and I extract data from them via calculated column ( with lookupvalue) to my main table. Then I made some basic math calculations, still with calculated columns. There's no measure in my screenshots,  but when I tried to write the measure so I can post, I figured my mistake. 

I didn't add "count" function to my measure, when I added it works.

 

= CALCULATE(COUNT(Listing[Product]);Listing[Day]="Without Stock")
 
thanks for your help