Forum Discussion
COUNTIF on a New Measure
Hi, I'm having challenge with counting the number of rows, when a New Measure is over a certain limit. e.g. I have a table with multiple transactions for multiple people in terms of Amounts De...
batranikhil , Please refer these measures
% Withdrawn = Divide(Sum(Table[Amount Withdrawn]), Sum(Table[Amount Deposited]))
% GT 100 = countx(Values(Table[Name]), if([% Withdrawn] >1 , [Name], blank() ) )
Thanks Amit - worked beautifully.
Can you also help with what to use if I were to build a pie chart depicting 5 groups:
above 200%, 100-200%, 76-100%, 50-75%, and less than 50%.
Any direction would help.
Cheers,
Nikhil