Forum Discussion
Need help in adding a measure
Hi I have a matrix visual included in my dashboard like shown below in the table. It basically tells for each TLs, the teams Met the target or Not. The fact table contains employee level data and th...
Anonymous
You should unpivot the table to make the dax calculations easy.
1. Go to query editor, hold on Ctrl, select Sale1-7 columns, and unpivot.
2. Close and apply, create the following count measure.
Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table',[Value]="Met"),ALLEXCEPT('Table','Table'[TL]))Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
You should unpivot the table to make the dax calculations easy.
1. Go to query editor, hold on Ctrl, select Sale1-7 columns, and unpivot.
2. Close and apply, create the following count measure.
Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table',[Value]="Met"),ALLEXCEPT('Table','Table'[TL]))
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.