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
djurecic
Super User
Super UserHi Anonymous,
Glad that helped. I'm not sure I understand the second issue- can you please explain what is happening now and what you are looking for?