Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |