Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have Matrix
see example bellow
Matrix 1 show all the records
Matrix 2 has filter to exclude "client" from calculation in just this visual
Client want to have single matrix
with 2 totals (one after another or side by side)
where
All records will be shown ,but second total with show results without "client"
Any idea how dispaly this info?
Thank you
Solved! Go to Solution.
Hi @Alex_G7 ,
You can create a measure like this
Measure = IF(HASONEVALUE('Table'[User]),BLANK(),CALCULATE(SUM('Table'[Values]),'Table'[User]<>"A"))
Then in the Field formatting, set the font color to white and apply it to header.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Alex_G7 ,
You can create a measure like this
Measure = IF(HASONEVALUE('Table'[User]),BLANK(),CALCULATE(SUM('Table'[Values]),'Table'[User]<>"A"))
Then in the Field formatting, set the font color to white and apply it to header.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Alex_G7 , two totals are not possible as of now. you can place the two, one behind the other and try
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |