Forum Discussion
Solved
Creating a measure to Count based on conditions from another measure
Hello Community, I am trying to create a card that displays the number of territories that total outside of a range of 0.85 to 1.15 in a measure that calculates this index. Does anyone have a...
CNT = COUNTROWS( FILTER( ALLSELECTED( CustomerWorkloadIndex[Territory_KeyId] ), VAR __cwi = [CWI] RETURN .85 > __cwi || __cwi > 1.15 ) )
andhiii079845
Solution Sage
Solution SageHi, try this. You take the Territory_KeyId for the counting. You can change it, if you need. Thank you for your clear example. 🙂
CountMeasure =
Var _tb = SUMMARIZE('Table','Table'[Territory_KeyId],"_cwi",[CWI])
VAR _c = COUNTX(FILTER(_Tb,0.85<=[_cwi] &&[_cwi]<= 1.15 ),[_cwi])
RETURN _c
Mark the post as solution if it was helpfull.