Hi, I am experiencing an issue where a DAX measure:
Actual Closed- Won divided by Budgeted Closed-Won = DIVIDE( SUM('Weekly Summary'[Actual Closed- Won]), SUM('Weekly Summary'[Budgeted Closed-Won]) )
is not working when displayed as a 'card' visulization (big number tile), however, if I create a bar chart visualization I am getting the expected results. The calculation should = 0.86. I am wondering why the measure works when visualized as a bar chart but not as a Card type visualization.
Solved! Go to Solution.
This was it, I realized that I have to select on the field in order to make formatting changes, formatting changes won't apply to the visualization directly.