Forum Discussion
EaglesTony
Post Prodigy
3 years agoCard 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
- johnt75
Super User
In the formatting options for the card visual open Callout value and set display units to none.