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,
I've been expericing an unexpected behaviour with a cumulative dax measure
below the standard measure that I am using and a screenshot that illustrates my problem
Hi, @Tomasjhussey
Based on your description, I created data to reproduce your scenario. However, It works correctly. I assume that maybe other tables in the data model cause the problem.
Here is my result:
You may try to create a calculated table as follows.
Year table = Distinct(Forum[Year])
Then you can use the 'Year' column in Year table to create the line chart to check whether it appears normal. Please tell me your testing result. Thanks.
Best Regards
Allan
Hi @Tomasjhussey ,
Looking at the 3rd chart, there's about 9.9K gain causing a drop. Have you checked on the visual filter? It's probably filtered by something which affects just year 9. Otherwise, could you post your data or model?
Proud to be a Super User!
Hi @danextian
Thanks for your interest, the complete data is shown in the matrix. I can't publish the PBIX.
And yes, there is a slicer affecting that visual, in the screenshot you can see that there is a slicer is affecting 2 graphs, also a report level filter for SA and ACT . Other than that there is no visual level filter.
Thanks
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |