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.
I have written a DAX measure which correctly gets the average of a table, however, now that I have added a visual level filter I need the average to now get the correct average according to what is actually showing on the table currently not what it originally showed without the visual level filter.
Current Average = 0.47%
Expected Average = 3.08%
Visual Level filter which I added
Current Output:
Expected Output (Checked via Excel):
DAX Code:
AverageRate =
AVERAGEX (
VALUES (d_cam[owner_name]),
[SASRate]
)
Solved! Go to Solution.
I solved the issue by created a calculated table using the SUMMARIZE function then did a DAX measure based on that calculated table
Hi @Anonymous ,
Thanks for your solution. If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry
I solved the issue by created a calculated table using the SUMMARIZE function then did a DAX measure based on that calculated table
I am sure there are some other filters applying to the visual. get the dax query of the visual and check
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 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |