Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, I'm currently trying to filter gross sales by specific order types in such way that if I add date and order type to the row field in a matrix it'll show the data distributed by date and order type. However, the measure seems to work only with date as follows:
Once I keep drilling down to the next level which are the order types instead of only showing the order types that i need (035,036,037,038,040,041,042)it shows all of them and even worst with the same value which is wrong.
this is my measure:
Solved! Go to Solution.
I've modified my measure and it's working fine now
I've modified my measure and it's working fine now
the measure is likely fine. It's your data model that needs fixing. The same value down a column indicates a mis-wired data model.
The model is correct it was just the incorrect measure.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |