Forum Discussion
Helper IIIShow Zero in table
Hi Anonymous
Thx for your reply.
I change the code a little bit and it works.
Code:
Sum_income = var x = SUM(I_table[Income]) var _P_CatList = CALCULATETABLE(VALUES(P_table[P_Cat]),FILTER(I_table,I_table[Project type] IN VALUES(I_table[Project type]))) return IF(MAX(P_table[P_Cat]) in _P_CatList,x,x+0 )Thank You.
Best Regards,
Duncan
Helper IIIHi Ritaf1983 ,
Thx for your reply and it kinda works.
However, after applying other filters the categories just disappear instead of showing zero.
Thank You.
Regards,
Duncan
Super UserHi DuncanYeah
You need to create a model + formulas that serve your scenario...
- DuncanYeah
Hi Ritaf1983 ,
Sorry for missing the filter in the past example.
I recreate the pbix that have a filter inside.
https://drive.google.com/file/d/1Swv7apy3WZ9KXVwVEUdV8SJGhfLtILbo/view?usp=drive_linkSorry and thank you for your reply and effort.
Regards,
Duncan
- Ritaf1983
Now i don't understand what a desired result is...+
You add a row with a blank value...is this a value that should be 0?- DuncanYeah
Yes the value should be zero.
The desired result is replace blank value with zero without adding other categories to the table, which is not belong to the project type.
Regards,
Duncan