Forum Discussion

nareshr89's avatar
nareshr89
Icon for Helper II rankHelper II
3 years ago

DAX Help

I have a column "Table[ML]" with values from 1 to 12 and the same values in Dimension table Table1[ML]   When i select a value ex 1 in Dimension table, the main table column needs to be sliced with...
Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi nareshr89 
Please create the following filter measure, Place it in the filter pane of the visual, select "is not blank" then apply the filter.

FilterMeasure =
VAR SelecedML =
    MAX ( 'Table1'[ML] )
RETURN
    COUNTROWS (
        CALCULATETABLE (
            'Table',
            ALL ( 'Table1' ),
            'Table'[ML]
                IN { SelecedML, SelecedML + 1 }
        )
    )