Forum Discussion
Solved
Formatting to hide zeroes
Hi there Hope someone can help. I have a measure that calculates Gross Profit and Gross/Sales %, where I have formatted the Gross/Sales % as a percentage. My results are either whole num...
I worked it out
mahoneypat
Microsoft Employee
Microsoft EmployeeThree suggestions:
1. You can just use SWITCH instead of SWITCH(TRUE() in this case.
2. When you create all those variables, you are likely hurting performance as you are generating all measures everytime.
3. You should learn about Calculation Groups to get your desired functionality. You could then do a conditional format string, after you return BLANK() for any results that = 0 (before formatting).
Pat