Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Guys,
HELP!! 🙂
any help would be apprciated 🙂
Below is the formula i have found on the site it has achieved half my goal just need the other half and i believe it has to do with the count value below i have also added a screen of the data i would like the total count of brands in column 1, 2 and 3 for brands
ShowRow = IF ( HASONEVALUE(Brand[T]), IF ( COUNTROWS ( FILTER ( 'Training App', 'Training App'[Brand Covered] = VALUES ( Brand[T] ) ) ) || COUNTROWS ( FILTER ( 'Training App', 'Training App'[Brand Covered 2] = VALUES ( Brand[T] ) ) ) || COUNTROWS ( FILTER ( 'Training App', 'Training App'[Brand Covered 3] = VALUES ( Brand[T] ) ) ), 1, 0 ) )
Solved! Go to Solution.
Solved in the below link
after a change of searching
Solved in the below link
after a change of searching
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |