cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
musa Frequent Visitor
Frequent Visitor

DAX measure not working with Card visualization

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.

 

Thank you, 

 

 2018-03-05_16-42-41.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
anandav Established Member
Established Member

Re: DAX measure not working with Card visualization

@musa

For the card visual, did you try entering 2 in the 'Data Label' formatting 'Value decimal places'?

Capture.JPG

 

2 REPLIES 2
anandav Established Member
Established Member

Re: DAX measure not working with Card visualization

@musa

For the card visual, did you try entering 2 in the 'Data Label' formatting 'Value decimal places'?

Capture.JPG

 

musa Frequent Visitor
Frequent Visitor

Re: DAX measure not working with Card visualization

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.

 

Thank you!