Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear All, I have an issue with getting the correct result on aggregated levels. I have a model with three factables (all related to the same dim tables and also good to now it is in direct query mode);
Cost Per unit:
Bill of Materials
And a third one where I create the result, in the model this table is actualy empty and filled with a measure;
Where MeasureCost is the following
Solved! Go to Solution.
I found the solution. First calculated the measure, and then used another measure with sumx to also get it OK on aggregated level;
I found the solution. First calculated the measure, and then used another measure with sumx to also get it OK on aggregated level;
Found the solution, will post the pbix also
Will also post a simplified model
I think I'm almost there, formala need to besomething like
Hi, @Sander76
Can you decompressed your real-life problem into a simple case?
If you can provide a sample pbix for testing,it will helop us understand and deal with this problem.
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |