topic Re: Dax to show total cumulative in card visual in DAX Commands and Tips

Dax to show total cumulative in card visual

Learner27 — Mon, 11 Sep 2023 07:00:17 GMT

Hi Everyone tamerj1 , OwenAuger , some_bih

I have a dataset with live connectivity in my Power BI.
The issue I'm facing is that I've created a cumulative measure, which I named "Deluxe." Afterward, I multiplied it by 10.75 and displayed it as "Deluxe Revenue."

However, when I drop the same measure into a card visual, I only get a total value for August, which is 492. But my requirement is to display the total of Deluxe Revenue

Here is the snip of my data :

Please help me to solve this issue your help is greatly appericiated
Thanks in Advance

Re: Dax to show total cumulative in card visual

some_bih — Mon, 11 Sep 2023 07:37:21 GMT

Hi Learner27 not everything is shown from your model / canvas so please anwser following

do you have something filtered on dashboard / canvas? ...So it shows only 492.

"total of Deluxe Revenue" - mean YTD total or overall total...

Re: Dax to show total cumulative in card visual

Learner27 — Mon, 11 Sep 2023 07:50:33 GMT

Hello, some_bih
There are no filters applied to my dashboard or canvas, and the Deluxe revenue represents the year-to-date (YTD) total. However, in the card visual, I want to display it as the overall total.

65+229+339+405+427+459+470+492=2886

I need this 2886 value in card but im unable to show this

Re: Dax to show total cumulative in card visual

some_bih — Mon, 11 Sep 2023 09:04:15 GMT

Hi Learner27 find following measure as test

YTD Deluxe Revenue test = TOTALYTD (SUM(YourTable[Deluxe Revenue]), 'Dim Date'[Date])

Adopt YourTable[Deluxe Revenue] if is wrongly written

'Dim Date'[Date] - check if your key column is Date or something else so adopt this part

Hope this help, kudos appreciated.

Re: Dax to show total cumulative in card visual

Learner27 — Mon, 11 Sep 2023 09:09:03 GMT

hello some_bih
Deluxe Revenue itself is a measure not a column

Re: Dax to show total cumulative in card visual

some_bih — Mon, 11 Sep 2023 09:24:22 GMT

Hi Learner27 try below

YTD Deluxe Revenue test 2= TOTALYTD ([Deluxe Revenue], 'Dim Date'[Date])