Forum Discussion
Help with Matrix data using double category in the field
The [Count] column indicates how many times the value in the [Note] column is found.
In the first case for the account, there is only 1 element that satisfies Account:1,Name:Eg.1,Note = A
Compared to the condition Account:1, Name:Eg1,Note=B
There are 2 rows containing this letter.
The average is calculated depending on the color. The gray color is the general average.
In the case of orange color, it is the average for the Name section.
Finally the "Average" is calculated with respect to the total rows that satisfy certain conditions with respect to if the status is 1.
Account:1,Name:Eg1,Note:B = 2 rows found. Where one of them has status 0 and another with status 1
Still not sure of what you want but i have donw something. Download the PBI file from here.
Hope this helps.
