Forum Discussion
How to create a dax function that works both in table context and in the context of Total?
Hello, I am new to PowerBI. I hope someone can help as I've been struggling for a few hours. Let's say I have the below data. date event_label trials associated with events trials p...
Please see this video for how to get your expected total.
(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
In your case, you likely need something like
NewMeaure = SUMX(VALUES(Table[Date]), [Trials associated with events])
Pat
Hi djurecic ,
Thank you for your response. That gives me a very nice way to separate the row level from the total overview. I am still stuck on how to apply the date group by context on the contextless Total. Would you be able to help me with that? If you edit your last message then I can mark it as having solved the entire problem.