The "Total" is blank in the Table visual

[kldefens]

Hey guys,

I've created a measure called "IF_cond C&O-calculated". 
Example: This measure will multiply column "C&O-Calculated%" with 100 if the column "VullingTotaalPerc" is 100 %.
The measure is working fine but it won't show a grand total of percentage. Can anyone help me out?

• First column [VullingTotaalPerc] shows the percentage of version ID that are filled 100% and so on
• Second column [Productieafdeling] shows the department
• Third column [C&OCalculate] is a measure that I created that shows the count (distinct) of the total version ID but only for department X.
  Measure = TotalVersiesidCalculate = calculate(DISTINCTCOUNT(MKA[Versies.Id]),MKA[ProductieAfdeling]="COC2 en I&V")
• Fourth column [C&OCalculate%] is a measure that I created to see what the percentage of the total.
  C&O-Calculated% = DIVIDE([C&O-Calculate],CALCULATE([C&O-Calculate],ALLSELECTED()))
• Fifth column is a measure that I created to multiply column  [C&OCalculate%] with column [VullingtotaalPerc].
  Down below is the measure:

IF_cond C&O-calculated =

VAR valling = SELECTEDVALUE(MKA[VullingTotaalPerc])

RETURN

SWITCH(TRUE(),

valling= "100 %", MKA[C&O-Calculated%] * 1,

valling= "90 %", MKA[C&O-Calculated%] * 0.9,

valling= "80 %", MKA[C&O-Calculated%] * 0.8,

valling= "70 %", MKA[C&O-Calculated%] * 0.7,

valling= "60 %", MKA[C&O-Calculated%] * 0.6,

valling= "50 %", MKA[C&O-Calculated%] * 0.5,

valling= "40 %", MKA[C&O-Calculated%] * 0.4,

valling= "30 %", MKA[C&O-Calculated%] * 0.3,

valling= "20 %", MKA[C&O-Calculated%] * 0.2,

valling= "10 %", MKA[C&O-Calculated%] * 0.1

)

[Mahesh0016]

Check data type of Measure.

[Mahesh0016]

can you share pbi file for more understandig.

[kldefens]

Hi, I can't share the file because it is too big and confidential. I've tried to recreate the dataset but It isn't the same. Is there another way you can help me?

[kldefens]

Already did but nothing is happening..