Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In PowerBI I'd like to build Non-standard matrix very similar to the report in Google Analytics.
I want to change my subtotal to measure, which is calculated as the difference in percentage of the two values
If it's possible, help me please)
No, it's not possible. Currently, it's not supported to custom the subtotal into measure. Even you can change the subtotal, it still can't calculate the difference between two entries. Because the measure must aggregate all entries under the row group, if there's more than two entries, the measure can't determine which two entries should be picked up for calculation.
Regards,
@v-sihou-msft, thanks for you answer.
Maybe it possible without "SubTotals"? For example, add a measure or column to the table.
Is there any possibility of presenting data in this form (as in GA)?
Does anyone know how to do this?