Forum Discussion

nic88's avatar
nic88
Frequent Visitor
3 years ago
Solved

Count of a value

Hi, I'm having an issue with a measure I'm trying to write.   I have a table with a partner name as a row and sub rows for different benefits associated with that partner. The column 'plan count' i...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    nic88 , Try like

     

    Count of Plan benefits = CALCULATE(
    COUNT(Benefits[Partner]),
    filter( ALLSELECTED(Benefits),Benefits[Partner] = max(Benefits[Partner]))
    )

     

    Or use removefilters for the level having value Risk Advisor etc

     

    Count of Plan benefits = CALCULATE(
    COUNT(Benefits[Partner]),removefilters (Benefits[Level 2]) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

nic88 , Try like

 

Count of Plan benefits = CALCULATE(
COUNT(Benefits[Partner]),
filter( ALLSELECTED(Benefits),Benefits[Partner] = max(Benefits[Partner]))
)

 

Or use removefilters for the level having value Risk Advisor etc

 

Count of Plan benefits = CALCULATE(
COUNT(Benefits[Partner]),removefilters (Benefits[Level 2]) )

nic88's avatar
nic88
Frequent Visitor
3 years ago

I used the second solution and it worked! Thank you!