Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

CALCULATETABLE Question

I am trying to wrap my head around why the following measure works the way I want it to, but not the way I would expect or can explain:   COUNTROWS(CALCULATETABLE(ClientInfo,ClientInfo[Client Numbe...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Having slept on it, I'm now wondering to myself why I didn't understand this. By leaving the "ClientInfo[Client Number] <> VALUES(ClientInfo[Client Number])" line in the measure, I'm resetting the filter on ClientInfo[ClientNumber] and getting a count of the rows where other slicer values are limiting the number of clients minus the currently selected client. 

     

    Sleep...is there anything it can't do? (Said in your best Homer Simpson voice.)

     

    Eric

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Having slept on it, I'm now wondering to myself why I didn't understand this. By leaving the "ClientInfo[Client Number] <> VALUES(ClientInfo[Client Number])" line in the measure, I'm resetting the filter on ClientInfo[ClientNumber] and getting a count of the rows where other slicer values are limiting the number of clients minus the currently selected client. 

 

Sleep...is there anything it can't do? (Said in your best Homer Simpson voice.)

 

Eric