Forum Discussion
COUNT and PERCENT over specific ROW
I am having a hard time figuring out how to do a simple % over a specific row in a Matrix - thought it would just be a simple calculation but apparently it's not that easy? I have a matrix with 3...
The Matrix is just the visualisation. The DAX formula will depend on the table structure in the data model.
So, assuming you have a table called 'Data' with a column called [Type], you could write these 2 DAX Measures
Line Count = countrows(Data[Type]) % of Comment 1 = divide([Line Count],calculate([line Count],data[type]="Comment 1"))