DAX for passing filter context to dimension from measure

[rob_vander2]

I have below data with columns ID,Number & Name. I want to count the distinct IDs for maximum Number value. I am using below DAX in KPI which works fine
calculate( distinctcount(Table[ID], Table[Number]=max(Table[Number]))

But, I want to pass the condition of measure to table visual where there is other dimension. 

I have provided Number as filter. If no filter is selected table visual should be filtered for max Number. If I select any other value from Number, table visual should filter based on that selection. Please see the attached screenshot of requirement

[v-sdhruv]

Hi @rob_vander2 ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @rob_vander2 ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @rob_vander2 ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[johnt75 · Accepted solution]

You could create a measure like

Row is visible =
VAR MaxNumber =
    CALCULATE ( MAX ( 'Table'[Number] ), REMOVEFILTERS () )
VAR CurrentNumber =
    SELECTEDVALUE ( 'Table'[Number] )
VAR Result =
    IF (
        (
            NOT ( ISFILTERED ( 'Table'[Number] ) )
                && CurrentNumber = MaxNumber
        )
            || ISFILTERED ( 'Table'[Number] ),
        1
    )
RETURN
    Result

Add this as a filter to the table visual and set it to show only when the value is 1

[rob_vander2]

@lbendlin  can you explain why it's not possible?

[lbendlin]

Not possible within the same table. You need to use a disconnected table for the Number slicer.