Forum Discussion
COUNT IF
I have two values, the Limit value and the produced value. I need to do a Count IF and I need to account for all amounts above the Limit. I tested this calculation here but it is counting all...
Hi,
You are trying to run it like a loop and increment the count value which won't work, instead try this:
1. Create a column with new column = IF((Amount - Limit)>0,1,0)
2. SUM[New column]
Let me know if this works.
Hi Anonymous ,
Create a measure
Count greater than limit = COUNTROWS( FILTER ('Table', 'Table'[VALUE] > 'Table'[LIMIT]) )
Hi Anonymous ,
Create a measure
Count greater than limit =
COUNTROWS(
FILTER
('Table', 'Table'[VALUE] > 'Table'[LIMIT])
)
But what about when the limit value is in another table? I did the data modeling between the two.