Wrong total with dax measure

[andreasalleslev]

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

[wdx223_Daniel]

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

[andreasalleslev]

Hallo

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

[AlB]

Hi @andreasalleslev 

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 

[andreasalleslev]

Hallo

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

Best regards Andreas