Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicing two tables

Hello, I’m relatively new to DAX and struggling with the following, so any help would be greatly appreciated. Apologies, if this has been asnwered already, but I couldn't find anything similar.   I...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could try SELECTEDVALUE() function.

    Count=
CALCULATE (
    COUNTA ( 'Table1'[Combination] ),
    FILTER (
        'Table1',
        SEARCH ( SELECTEDVALUE ( 'Table2'[ID] ), 'Table1'[Combination],, 0 )
    )
)

    But I think the count of c should be 2 when you select x. 

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you again, and please forgive my insistence! I appreciate your patience

 

When I aggregate by MAX (or MIN) I get the same results for each ID level and therefore lose valuable information:

IDCount
a2
b2
c2
d2

 

Instead of:

IDCount
a2
b1
c1
d1

 

Greg_Deckler 

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

You could try SELECTEDVALUE() function.

Count=
CALCULATE (
    COUNTA ( 'Table1'[Combination] ),
    FILTER (
        'Table1',
        SEARCH ( SELECTEDVALUE ( 'Table2'[ID] ), 'Table1'[Combination],, 0 )
    )
)

But I think the count of c should be 2 when you select x.