Forum Discussion

syasmin25's avatar
syasmin25
Helper V
6 years ago
Solved

IF (DAX)

Hello,  I am very much new to DAX calculations and was wondering if you guys could help me out with this. I am attaching an example of what I am trying to replicate in Power BI here. In the attach...
General Comment
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi syasmin25,

    You can create one measure as below:

    salaryR = var a=max('Table_2'[ID])
    var b=CALCULATE(max('Table_1'[Quantity]),'Table_1'[ID]=a)
    return if([Quantity_Sold]>b,"Yes","No")
     

    Best Regards

    Rena

syasmin25's avatar
syasmin25
Helper V
6 years ago

Table_1

Table_2

I created a measure that shows the Quantity sold:

 

And then I added a Quantity Column for inventory:

Now if I want to see if Quantity_Sold(

COUNTA(Table_2[Product])) is Greater than Quantity (Column from Table_1), then put yes else no. And that is where I am having difficulty since one is a measure and the other one is just a column. 
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi syasmin25,

You can create one measure as below:

salaryR = var a=max('Table_2'[ID])
var b=CALCULATE(max('Table_1'[Quantity]),'Table_1'[ID]=a)
return if([Quantity_Sold]>b,"Yes","No")
 

Best Regards

Rena

  • syasmin25's avatar
    syasmin25
    Helper V
    6 years ago

    Thank you so much. It works!