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
Here is the picture of the Matrix
PaulDBrown
Community Champion
Community ChampionYou need to create a dimension table for MODELLO and use that in the visual:
Thank you for your answer! This is close to what I need...But the measure (%) is going to 100% for all values...
- PaulDBrown
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