Forum Discussion
Solved
ISBLANK() or Measure +0 not working
hello! I am trying to substitute the blank values I have in this small Matrix with 0 for further calculation I have written this simple measure based on other answers I have found but it is sti...
Yes. You need to change the measure to reference the field from the dimension table:
% = VAR currentImporto = [Sum - IsBlankMeasure] VAR AllImporto = CALCULATE( [Sum - IsBlankMeasure], ALL('DModello'[MODELLO]) ) var ratio = DIVIDE(currentImporto,AllImporto) return ratio
Thank you for your answer! This is close to what I need...But the measure (%) is going to 100% for all values...
PaulDBrown
Community Champion
Community ChampionYes. You need to change the measure to reference the field from the dimension table:
% =
VAR currentImporto = [Sum - IsBlankMeasure]
VAR AllImporto =
CALCULATE(
[Sum - IsBlankMeasure],
ALL('DModello'[MODELLO])
)
var ratio =
DIVIDE(currentImporto,AllImporto)
return
ratio