Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have recently been playing with the Matrix visual on a flat data source and trying to find ways to selectively display different values on different rows. Currently the visual looks like this:
What I want to be able to do is display the value for the column calcHasAttachment (circled in red) to display in the position circled in blue, whil retaining the Bottom total.
For reference, the formula I am using for calcHasAttachment (and is typical to calcTotal) is as follows:
calcHasAttachment = IF(NOT ISINSCOPE(ExampleFormData[ItemID]),MIN(ExampleFormData[HasUpload]))
Also, for reference, the formula for calcItemDescription is (which displays data at the ItemID level and is typical to calcCost):
calcItemDescription = IF(ISINSCOPE(ExampleFormData[ItemID]),MIN(ExampleFormData[Description]))
Does anyone know how I can achieve this?
Thanks
play with these settings
Thanks. I had a play with it yesterday but was only able to get it to show on the same row as the totals. Its about that separation away from the total row that I am trying to do.
Looks like it is bound to the total row, which is not ideal, but will have to suffice, unless someone else can suggest an alternative.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |