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
Super UserHi DuncanYeah
You need to create a model + formulas that serve your scenario...
Helper IIIHi 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_link
Sorry 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
- Ritaf1983
DuncanYeah
You can replace the blank value with zero from PQ :If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly