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
ppm1
Solution Sage
Solution SagePlease 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 Pat. Thank you for your help. I modified it to the below and it worked. And it workes by itself without separating the row level from the total level.
SUMX(SUMMARIZE(Table,[date], [trials per day]), [trials per day])
I will check out your youtube channel when I have a bit of time to pick up some more knowledge.