Forum Discussion

Analitika's avatar
Analitika
Post 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

Hello Analitika ,
Instead of format try like this 

[MesureDivide] &"0.00%"
Analitika's avatar
Analitika
Post Prodigy
5 years ago

Anonymous

Not work as showing zeroes value

 

 

  • 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
      Post Prodigy
      5 years ago

      Then everything works instead of formating to %