Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Card visual is showing a different value compared to column and waterfall charts

Hello,   Has anyone had this problem before - I have a measure in my report and i used it in 2 visuals: Card Clustered column chart However, Im getting 2 different totals in the 2 visuals. I u...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    Sorry, I realize my error.  My measure should be

    TOTAL CTC Months = SUMX ( VALUES ( Date[Month Year] ), [TOTAL CTC] )
gtacchini's avatar
gtacchini
Icon for Advocate I rankAdvocate I
5 years ago

Try a simple SUM, you'll see they match.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hi gtacchini  can't use SUM because my TOTAL CTC is a measure 😞