If the value is Blank it must be 0

[Kent1341]

Hi,

I have a problem with my sum's. The problem is that if a manufacturer doesn't have a product in this subsegment, it doesn't give the value 0 but it gives a blank value. My calculation is very simple 

FACT VALUE = sum(Data[Sales Value]).

I have tried if(isblank(sum(Data[Sales Value])),0,sum(Data[Sales Value])) with no lock.

My problem is that I want to calculate the total share and of a manufacturer and you can see below that when the first and second are chosen the value is 15,1% and when it's only the first that is chosen the value is 18,8%. 

Can anyone help me?

Br Kent

[amitchandak]

@Kent1341 , Not very clear. As at end seem like you are looking for something else

sum(Data[Sales Value])+0 should handle the blank. But it work best when sub segment 1 is from another dimension

for % of total

divide(sum(Data[Sales Value]), calculate(sum(Data[Sales Value]), allselected() ) )