Forum Discussion
jaymanivannan
9 years agoFrequent Visitor
Calculated Measure with conditions
Hi, I am new to PowerBI. I am trying to create a calculated measure based on the condition. For Example, I am trying to create measure for the following condition SalesAverage= ((SUM(Total Sales...
- Anonymous9 years ago
jaymanivannan response is great. To add to this, rather than using the / symbol and have to make a divide by zero check, just use the Divide() function. I've also set this out using a spacing format, which is a good habit to get yourself into.
Here is an updateSalesAverage = DIVIDE( CALCULATE( SUM(Total Sales $), [AccountCode]=410000 ), CALCULATE ( Sum(Total Sales Quantity), [AccountCode]=420000 ) )
Im_SD
3 years agoNew Member
Hello!
How do you write this code in DAX?
Select column1
from table1
Where column3>column2;
(Consider column1 as text field and column 2 and 3 as value field).