Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there
I'm trying to calulcate an average figure (simple usually). However this figure needs to be based on a calculation of overall per year then drill to month and then drill to week. So against every person for those drill periods I want the average to be the same against each person. Then if the average changes the following week I want the new average figure to be the same for every person. I can then create a conditional format against it.
The DAX I have created works on a card visual level when I select a particular week, but as soon as I drop it in to my table where all the user names and years/months/weeks are listed the figure changes
E.G Week 45 card visual saya 29.57 but when I add it to the table it breaks down like this (column highlighted in yellow)
In that table are weeks for the last 12 months. As you can see the total for the column is correct at 29.57 but I just cant get it to work against each individual person.
My DAX is
Solved! Go to Solution.
HI there
I managed to resolve the issue by using this
Thanks for getting back to me
Kind regards
Karen
You are using CALCULATE without a filter context modifier. Is that intended?
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.
HI there
I managed to resolve the issue by using this
Thanks for getting back to me
Kind regards
Karen
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |