DAX measure with multiple IFs
Hello, Please can you help me to write this DAX measure in Power BI? I have 5 columns with multiple combinations (A - E) and F column which summarize the columns A - E. I need to obtain the result from column "RESULT" and I don't know what formula should I use. Thank you for your support.
IF statement returns 0%
Hi guys, My previous colleague wrote an Dax If statement to return a percentage of a number. Below you can see the dax statement The problem is that I don't understand this statement. Dax If statement: " ProductivityA = IF([InvoicingTargetInHours] - [NormWorkingHours] = 0, 0, IFERROR(([InvoicingTargetInHours] / [NormWorkingHours]), 0)) " The measure is calculating the percentage correct if the InvoicingTargetInHours and the NormWorkingHours are different, see picture below: But once the InvoicingTargetInHours and the NormWorkingHours are the same number, it return 0% when in fact it should return 100% as productivity, see picture below: Can someone help explain this statement to me and how I should fix this dax? Should I rewrite or not? Im clueless at this point. Thanks guys!
If Then Formula
How would you write a formula for a new column that only populates the value from the "YTD-2020M06-Installation Jobs" column if the value in the "Booked vs Actual" column is "Total Booking" AND the value in the "Sell Price/Earned Revenue & Gross Margin/Gross Profit" column is "Gross Margin/Gross Profit"?
