Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have created two PBIX file, everything is the same, except for the date dimention is useding a string, 1-8, instead of a date.
With that being the only change, I am getting getting different results on productx measure
Link to the two PBIX Files
https://docs.mobius.kiwi/f/4526097a6d2e49cdbd5c/
The measure I am using is
Solved! Go to Solution.
That does look like it works on the file I sent over.
I just tried it on my main file, I still have the same issue.. Any ideas?
Disable auto date/time globally.
Takes, forgot ther is one for global and one for dataset.
However, playing around with it more (making it work with my main dataset, i was still having isssues), for some strange unknown reason, on the date table as soon as I create Day Number Column
Can you provide a pbix that demonstrates the issue?
https://docs.mobius.kiwi/f/25c11a74ec9c4891bbe9/
Look at the tmpmreturnsproduct , returning all 100's.. then delete the column day number column and the measure calculates as you would expect.
I did some mild refactoring. You will want to avoid nested measures if you can, and fancy filter constructs.
I seem to recall that the Italians have already written about your scenario. Something about a covering column that needs to be included in the filter context.
Thanks for that, time go back to reading the fundementals....
Thanks... Would love to know what / why that causes the problem.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
9 | |
9 | |
6 | |
5 |
User | Count |
---|---|
17 | |
15 | |
10 | |
9 | |
8 |