Card showing value incorrect from using Measure in DAX query

EaglesTony — Tue, 02 May 2023 13:34:39 GMT

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)

Re: Card showing value incorrect from using Measure in DAX query

johnt75 — Tue, 02 May 2023 13:43:16 GMT

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

topic Card showing value incorrect from using Measure in DAX query in DAX Commands and Tips

Card showing value incorrect from using Measure in DAX query

Re: Card showing value incorrect from using Measure in DAX query