Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I created a Measure to calculate profit %. I would like all negative percentages to show as 0%. Here is the DAX used to create the measure
Profit% = DIVIDE(SUM(TABLE1[Net Profit]), SUM(TABLE1[Revenue Total]),0)
Can I include an IF statement in my current DAX and if please post an example.
Thanks
Solved! Go to Solution.
You should be able to add to your measure, or refer to it as another measure.
Profit% = IF( DIVIDE(SUM(TABLE1[Net Profit]), SUM(TABLE1[Revenue Total]),0) )<0, 0, DIVIDE(SUM(TABLE1[Net Profit]), SUM(TABLE1[Revenue Total]),0))
or
New measure = IF ([Profit%] <0, 0, [Profit%])
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
You should be able to add to your measure, or refer to it as another measure.
Profit% = IF( DIVIDE(SUM(TABLE1[Net Profit]), SUM(TABLE1[Revenue Total]),0) )<0, 0, DIVIDE(SUM(TABLE1[Net Profit]), SUM(TABLE1[Revenue Total]),0))
or
New measure = IF ([Profit%] <0, 0, [Profit%])
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Worked perfectly. Thank you.
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |