Forum Discussion
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...
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
Thank you so much for your help. I apologize for the inconvenience but I forgot to mention that the "Estimated Sales Price" is a measure which I have turned into the column in Power BI. However, even then it does not seem to work.
Hi syasmin25,
Could you please provide your table structures and the formula of measure "Estimated Sales Price" in order to find the cause of problem? It is better if you can provide your PBIX file (exclude sensitive data). Thank you.
Best Regards
Rena
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.