Forum Discussion

DuncanYeah's avatar
DuncanYeah
Icon for Helper III rankHelper III
1 year ago
Solved

Show Zero in table

Hi everyone,   I am trying to get my table to display categories with number count zero. I had tried to use +0 but after appling page filter, the table showed some categories that not match the pa...
Need Help
Show and Tell
Tips and Tricks
  • DuncanYeah's avatar
    DuncanYeah
    1 year ago

    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

     

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
1 year ago

Hi DuncanYeah 
Try this formula :

Sum_income =
var tab = SUMMARIZE(I_table,I_table[Project type],"sum_",sum('I_table'[Income]))

return
SUMX(tab,[sum_])
 
 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

DuncanYeah's avatar
DuncanYeah
Icon for Helper III rankHelper III
1 year ago

Hi 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