Forum Discussion
Solved
How to calculate total Sum in Matrix visual with complex calculation?
I am stuck with a problem for some time now, and hope to get some help here. My data contains these for example: "Count" is the number of available positions in our case, "level" the perc...
Hi OliTFD check out my blog post on this (I had a similar case where I wanted to sum quantities per productid , I am pretty sure you will find it useful). It is based on the SUM() OVER PARTITION BY of SQL , I think you can also use the same logic for your COUNT https://www.iipowerblog.com/post/sum-over-partition-by-in-powerbi
amitchandak
Super User
Super User