Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
34 | |
14 | |
14 | |
12 | |
9 |