Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all,
I have one table which i am using to sum the buyed licenses per each SnapShotDate_.
In the SnapshotDate_ there must be only 4 dates which are: 2/2/2018, 2/3/2018, 2/4/2018 and 2/5/2018 to make the calculation of the SUM of BuyedLicense.
The expected result of the solution must be:
Picture 1:
But in my table i have in the column Snapshotdate_ differents 2/2/2018, 2/3/2018, 2/4/2018 and 2/5/2018. This result in an wrong calculation.
Picture 2:
W
Any suggestions to get the result of the first picture ?
Many thanks
Solved! Go to Solution.
Hi @Anonymous
This behavior occurs because there is no relationship between tables Fact Order user license and Fact user license new. To solve it, set Cross filter direction as both for the relationships you have with the dim date table.
Regards.
Hi @Anonymous
This behavior occurs because there is no relationship between tables Fact Order user license and Fact user license new. To solve it, set Cross filter direction as both for the relationships you have with the dim date table.
Regards.
This is my current model right now:
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |