Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
5 years ago

Hide Columns with no data

I have measure   Measure= VAR val1 = IF ( ISINSCOPE(Table1[Names]), BLANK(),                                 FORMAT ( [MesureDivide], "0.00%" ) ) VAR val2 = [COGS]                          ...
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Can you just check this [MesureDivide] and instead of format return this [MesureDivide] and check are you getting the expected value?

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
5 years ago

Then everything works instead of formating to %