Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate symmetric mattrix

Hi experts,   I'm calculating a symmetric matrix with following tables (It is just a portion of the data):   Sport A Label Sport B Label QtUsersIntersection QtUsersSportOther Baloncesto ...
General Comment
Need Help
Show and Tell
  • Cmcmahan's avatar
    Cmcmahan
    7 years ago

    Sure.  Is your visual always going to have the fields in alphabetical order? If so, you just need a minor change to your measure. Otherwise, you'll need some sort of other ranking system to let PowerBI know the order of the categories.

     

    % us = CALCULATE(DIVIDE(SUM(SportsIntersection[QtUsersIntersection]);Sum(SportsIntersection[QtUsersSportOther]); 0); FILTER(SportsIntersection; SportsIntersection[Sport A Label]< SELECTEDVALUE(SportsIntersection[Sport B Label])))
Cmcmahan's avatar
Cmcmahan
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Sure.  Is your visual always going to have the fields in alphabetical order? If so, you just need a minor change to your measure. Otherwise, you'll need some sort of other ranking system to let PowerBI know the order of the categories.

 

% us = CALCULATE(DIVIDE(SUM(SportsIntersection[QtUsersIntersection]);Sum(SportsIntersection[QtUsersSportOther]); 0); FILTER(SportsIntersection; SportsIntersection[Sport A Label]< SELECTEDVALUE(SportsIntersection[Sport B Label])))