Forum Discussion

EaglesTony's avatar
EaglesTony
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Card showing value incorrect from using Measure in DAX query

Hello,

 

  I have a table, which I am creating a measure to calculate a sum of a column from another table.

  

GrandTotalAgingDays = SUM(Merge1[AgingDays])
 
   This value looks to be somewhat correct when I map it to the card, however the card is showing it 814K. (The actual value is 813, 528). I want to show the 813,528 and checked the following:
 
1) The field it is summing from the other table is defined as a whole number, but I do notice it has the  next to it.

 

2) The GrandTotalAgingDays is defined as a whole number
 
  Any ideas ? (I'm open to doing this calculation in PowerQuery if necessary)
  • In the formatting options for the card visual open Callout value and set display units to none.

1 Reply

  • In the formatting options for the card visual open Callout value and set display units to none.