The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hoping this is an easy fix since I'm so close to what I want to show, but I need to finish this asap so any help is appreciated!
I currently have a measure that indexes data against a norm across weeks and I'm using this measure in the value field of a matrix.
The requirements are that I only show the latest two weeks averaged together in this matrix.
So I wrote a calculated column that surfaces true if the week is the latest two weeks.
When I apply that calculated column as a filter or slicer to the matrix and the weeks are listed out, then the filter condition works just fine and only the relevant data surfaces.
However, when I collapse the weeks and only show the top category row, it no longer averages just the two relevant weeks for some reason?!
Does anyone know why this might be happening?
In this screen grab there is data for -4 through 0, but in the expanded unformatted table only the correct data is showing.
If I take that table and collapse to the higher level row then it no longer averages just those two values (see the data point on the right in the same table that's been formatted):
Thank you!
Hi @mpml ,
I am unable to reproduce this problem for the time being. Can you provide the relevant test data so that I can do further testing?
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Looking forward to your reply.
Best Regards,
Henry
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |