March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
26 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
40 | |
27 | |
27 | |
21 | |
20 |