Forum Discussion
Solved
Matrix Table Measure Needed
I use a Matrix table and I have numeorus values used to create column of data. I need help to write a meaure for one of the columns. I currently have a Field Claim Type and I just used the Fi...
Those are 3 measures.
Hi,
Does this measure work?
Total = countrows(Data)
Total across all claim types = calculate([Total],all(data[Claim type]))
% by claim type = divide([Total],[Total across all claim types])
Hope this helps.
What is Data in this scenario? Total is my Count Field and Claim Type is the Column.
Hi,
Data is the name of the Table.
I logically know what I need to do but having a hard time with
Total = countrows(Data)
Total across all claim types = calculate([Total],all(data[Claim type]))
% by claim type = divide([Total],[Total across all claim types])
Is the above One Measure or mulitple?
I aleady calculate Total.
Those are 3 measures.