Forum Discussion
Solved
DISTINCT COUNT WITH CONDITION AS OF MATRIX TABLE
Hello everyone, I have an issue to perform distinct count in this Dim_Attribute table: Index review_score Attribute Value 1 79.20% S6 100.00% 1 79.20% I1 100.00% 1 79.20% F...
Thank you, I tried but it did not work so well.
But I figure out sth this morning. I unpivot the attribute colum into multiple columns. Then I put multiple VAR condition for each column >=75% a green and <75% as red.
then return will be sum of count of every attribute.
It's kinda manual but so far it's correct 🙂
much appreciate your help ~~
Hello,
Apologies if I missed something here: what is the expected result?
I want to count the value appearing in the matrix table (which are values >=75%) of the attribute. However, my distinctcount shows 20 (total number of attributes)