Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |