topic Re: Wrong total with dax measure in DAX Commands and Tips

Wrong total with dax measure

andreasalleslev — Tue, 03 Nov 2020 19:26:49 GMT

Hallo Anybody

Hope someone can help me:-)

I have this measure:

Forbrugt Antal = IF(SUM('Optælling linjer'[Basis enheder]) <> BLANK(),

CALCULATE(SUMX('Optælling linjer','Optælling linjer'[Basis enheder]),USERELATIONSHIP(aabningsdage[ID_LastDay],'Optælling linjer'[ID_day]))

(CALCULATE(SUMX(Vaerdiposter, Vaerdiposter[Invoiced_Quantity]),Vaerdiposter[Day_7_Count]="false")*-1)

SUMX('Optælling linjer', 'Optælling linjer'[Basis enheder]),BLANK())

And here is the result:

I need the total calculated by the showing collums!!

Best regards

Andreas

AlB — Tue, 03 Nov 2020 20:28:33 GMT

Can you share the pbix? or a pbix with dummy data that repros the issue?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

wdx223_Daniel — Wed, 04 Nov 2020 00:31:00 GMT

andreasalleslev is it work to add a sumx out of your measure, iterating on year and month?

andreasalleslev — Wed, 04 Nov 2020 10:05:28 GMT

Hallo

Thank for ypu answar, I will try to make af file with dummy data and send to you.

Best regards Andreas

andreasalleslev — Wed, 04 Nov 2020 10:06:57 GMT

Hallo

I not shure what yoy mean. I have tryet to use sumx so some you se in the measure.