topic Re: Measure total in a Card Visual in DAX Commands and Tips

Measure total in a Card Visual

Neal1988 — Mon, 06 Sep 2021 15:58:19 GMT

i have the following measure that calulates the value for each row in a table visual.

RunRate =

VAR DayNoOfYear =

DATEDIFF(DATE(maxx(Points,Points[SurveyDateYear]),1,1), maxx(points,[StartDate]), DAY ) + 1

VAR DayNoOfYear2 =

DATEDIFF(DATE(

CALCULATE(maxx(Points,Points[SurveyDateYear]),ALLEXCEPT(Points,Points[SurveyDateYear],Points[Action]))

,1,1), NOW(), DAY ) + 1

VAR daydiff =

DayNoOfYear2-DayNoOfYear

RETURN

MROUND(

CALCULATE(

If(DayNoOfYear = 1, [Total],

([Total]/daydiff)*DayNoOfYear2

)

),0.5)

However, i need to get the total of this measure in a Card visual.

Can anyone please advise if this is possible?

Thanks in advance!

Re: Measure total in a Card Visual

Dhrubojit — Mon, 06 Sep 2021 16:09:21 GMT

Hi Neal Please attach the sample data and PBIX , you can remove your confidential data and just give part of it . .so that we can analyze better . . because it depends on what your data is

Re: Measure total in a Card Visual

Neal1988 — Tue, 07 Sep 2021 07:42:00 GMT

Hi, unfortunately all of it is confidential as we have a very strict privacy policy.
if you have any ideas that i could try, that would be appreciated.

For a bit of context, i have a table visual and one column is a staff members start date and the messure above calculates whats their score would of been if they where employeed at the start of the year. and it's this column that i need totalled, and put into a card.

Re: Measure total in a Card Visual

Neal1988 — Mon, 13 Sep 2021 08:06:03 GMT

I found the solution and it was to wrap a new measure in a Sumx(Summarize( which then gave the correct figures in a card.