Forum Discussion

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

Calculate function only when selected in filter

Hi I have a matrix with a measure that shows the total # of accounts for each sales person. The hierarchy is Director, Manager, Geography. This matrix is filterable by Geography, using the Geography...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

MichaelaMul Not quite sure I am following. Perhaps create an RLS rule based to filter the data just to what each Manager should see?

  • MichaelaMul's avatar
    MichaelaMul
    Icon for Helper III rankHelper III
    2 years ago

    Hi Greg,

     

    Sorry after reviewing my issue- I think my main problem is wanting to remove the geographies with blanks in the matrix that I have. So instead of needing to scroll to the Geography, even though it is listed for it to just show the geographies that it is filtered by.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi,

      Thanks fot the solution Greg_Deckler  provided, and i want to offer some more information for user to refer to.

      hello MichaelaMul , based on your descriotion, you can try the following measure

      # of Accounts =
IF (
    ISFILTERED ( Geography[Geography] ),
    CALCULATE ( COUNTROWS ( ( VALUES ( 'Salesperson Geos'[Geography] ) ) ) ),
    BLANK ()
)

      If the soution cannot meet your requirement, can you provide some sample output you want? becasue you sadi you want to display some value in matrix, which field do you put into the row and column of matrix?

       

      Best Regards!

      Yolo Zhu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.