Forum Discussion
Solved
Multiple filters, if and count
Hi I`m pretty new to Power I and i have a prolem that i can`t solve. I have different customer names and when they got a discount, i want to show that John is repeated 5, times for example, and 3 tim...
This measure should work:
Customers with ore than 2 discounts = VAR _DC = CALCULATE ( COUNTROWS ( fTable ), FILTER ( ALLEXCEPT ( fTable, fTable[Customer] ), fTable[Discount] = "Yes" ) ) RETURN IF ( _DC >= 2, _DC )
How can i count a measure? Maybe i have found a way to do what i want with first making a measure for the count of repetition of the names and now i need to count this measure only the times it`s repeated more than 5 times.
This measure should work:
Customers with ore than 2 discounts = VAR _DC = CALCULATE ( COUNTROWS ( fTable ), FILTER ( ALLEXCEPT ( fTable, fTable[Customer] ), fTable[Discount] = "Yes" ) ) RETURN IF ( _DC >= 2, _DC )