Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi and thx for reading this.
I have a simple table with 3 columns , Item , customer code and Sales (a whole number)
I put it in a Matrix table and it looks like this:
I would like to do a measure that checkes the Total Sum, it should be >=12
If i do this measure :
Solved! Go to Solution.
Hi @Ahmedx
Thanks so much for the suggestion.
My main thing here is to filter away the customer code (since in the main data there is alot of them)
So i dont want to see in this case A1 at all, but all the values that build up B1 and C1 as you have .
/Thx
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Sorry if i was not clear enough
This is the resualt i am looking for.
/thanks
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |