Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |