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.
Dear Experts,
Is there any chance to make the "(Blank)" instead to be set as "0" value?
Solved! Go to Solution.
Keep those as it.
Create 3 new measures
#POS Measure_NonEmpty = IF([#POS Measure] = BLANK(),0,[#POS Measure])
#RET Measure_NonEmpty = IF([#RET Measure] = BLANK(),0,[#RET Measure])
#OFF Measure_NonEmpty = IF([#OFF Measure] = BLANK(),0,[#OFF Measure])
Replace the measure in your cards by these ones.
I know it is annoying but I think the best way is to create a second measure_NoBlank. Creating another measure is better becuase if you still want to use it in a table or chart you won't get many dimensions with 0 next to it.
Something like this:
Offshore Sites = SUM(Offshore[Sites])
Offshore Sites_NonEmpty = IF([Offshore Sites]=BLANK(),0,[Offshore Sites])
Use the Offshore Sites_NonEmpty in your card.
Hi @Zaky,
Please try to add "+0" to your measure or IF(isblank(offshoresites),0,offshoresites).
Current measures that i'm use is as below.
So how can i add on to the current measure?
#POS Measure =CALCULATE(DISTINCTCOUNT('ICT Key Statistics July 2019'[AUPEC Definition]), 'ICT Key Statistics July 2019'[Physical or Travel] IN { "physically on-site"})
#RET Measure =CALCULATE(DISTINCTCOUNT('ICT Key Statistics July 2019'[AUPEC Definition]), 'ICT Key Statistics July 2019'[Physical or Travel] IN { "require engineer to travel"})
#OFF Measure =CALCULATE(DISTINCTCOUNT('ICT Key Statistics July 2019'[AUPEC Definition]), 'ICT Key Statistics July 2019'[Physical or Travel] IN { "offshore"})
Keep those as it.
Create 3 new measures
#POS Measure_NonEmpty = IF([#POS Measure] = BLANK(),0,[#POS Measure])
#RET Measure_NonEmpty = IF([#RET Measure] = BLANK(),0,[#RET Measure])
#OFF Measure_NonEmpty = IF([#OFF Measure] = BLANK(),0,[#OFF Measure])
Replace the measure in your cards by these ones.
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |