I have a matrix visual showing # of surveys taken and the NPS Score - both the # of surveys and the NPS Score are Measures I have created in my table. How can I have the values for the where the NPS AND the # Surveys if they both show 0, then leave those values blank.
As example for May2021 should show as follows:
Survey Type NPS # of Survey
30 Day 17 12
60 Day
90 Day
180 Day
Solved! Go to Solution.
returning 0 for both see below. While 0 could potentially be an NPS Score, so technically if we can just have it show blank for BOTH # of Surveys and NPS when the survey volume is 0.
Assuming your measure name is [NPS] and is some calculation like so.
NPS = SUM ( Table[Column] )
You can trick PowerBI into blanking it out like this.
NPS =
VAR _Value = SUM ( Table[Column] )
RETURN DIVIDE (_Value,_Value) * _Value
Because the DIVIDE returns a blank if it tries to divide by 0 and BLANK() * 0 = BLANK() it should work.
Is it hiding those rows instead or is your measure returning 0 for both? What is the result you are getting now?
returning 0 for both see below. While 0 could potentially be an NPS Score, so technically if we can just have it show blank for BOTH # of Surveys and NPS when the survey volume is 0.