Forum Discussion

SBR1D's avatar
SBR1D
Icon for Helper III rankHelper III
2 years ago
Solved

CountRows problem

Hi Everyone   Below is a simplified version of my actual table.   I have a slicer where a user can select an Employer name ( A,B,C,D), when they choose an employer I want to get a count of all of...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    The original formula takes into account that you might select more than one value which, in this case, SELECTEDVALUE will not work. If you want just a single selection:

    Number of Parent IDs =
VAR __PARENT_ID =
    CALCULATE ( MAX ( 'Table'[ParentEmployerID] ), ALLSELECTED ( 'Table' ) )
RETURN
    CALCULATE (
        COUNTROWS ( 'Learning Plan' ),
        'Learning Plan'[ParentID] = __PARENT_ID,
        USERELATIONSHIP ( 'Learning Plan'[EmployerId], Employer[EmployerId] )
    )

     

SBR1D's avatar
SBR1D
Icon for Helper III rankHelper III
2 years ago

That looks good but what about the selected value part please?

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

The original formula takes into account that you might select more than one value which, in this case, SELECTEDVALUE will not work. If you want just a single selection:

Number of Parent IDs =
VAR __PARENT_ID =
    CALCULATE ( MAX ( 'Table'[ParentEmployerID] ), ALLSELECTED ( 'Table' ) )
RETURN
    CALCULATE (
        COUNTROWS ( 'Learning Plan' ),
        'Learning Plan'[ParentID] = __PARENT_ID,
        USERELATIONSHIP ( 'Learning Plan'[EmployerId], Employer[EmployerId] )
    )