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.
Hello
I'm looking for a solution to get zero by default in the columns underneath when the adddition is = zero. Because the lack of numbers cut the lines of some graphics (see underneath). Thank you for your help.
Solved! Go to Solution.
HI @PatrickByGecko ,
You can add '+0' to you formula to replace blank result to zero:
CDI =
Table[CDI AIX-] + Table[CDI NIORT-] + Table[CDI PARIS-]+0
BTW, zero value also not display on charts, they will be filtered by visual itself.
Regards,
Xiaoxin Sheng
HI @PatrickByGecko ,
You can add '+0' to you formula to replace blank result to zero:
CDI =
Table[CDI AIX-] + Table[CDI NIORT-] + Table[CDI PARIS-]+0
BTW, zero value also not display on charts, they will be filtered by visual itself.
Regards,
Xiaoxin Sheng
Hi PatrickByGecko,
You can use the below measure to get zero wherever blank
CDI = if(calculate(sumx(Sumtable,Sumtable[price1]+Sumtable[price2]+Sumtable[price3]))=BLANK(),0,calculate(sumx(Sumtable,Sumtable[price1]+Sumtable[price2]+Sumtable[price3])))
Please do let me know if this helped you
It is a good idea. But I have just a problem with a circular reference between CDI DEPART and TURNOVER (I don't understand i see no relation betwen them).
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |