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 values 1 and 2 data only. Need a dax to filter the visula to show specific number and the next number data only.

 

 

Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    nareshr89 , Option one they are joined

     

    if(selectedvalues(Table1[ML]) =1, calculate(Sum(Table[Value]), filter(All(Table1), Table1[ML] in {1,2})), Sum(Table[Value]))

     

    in case they are not joined

     

    if(selectedvalues(Table1[ML]) =1, calculate(Sum(Table[Value]), filter((Table), Table[ML] in {1,2})), calculate(Sum(Table[Value]), filter( Table, Table[ML] in Values(Table1[ML]) ) ) )

     

     

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi nareshr89 

     

    try to feed the filter pane with a measure like:

    FilterMeasure =
    VAR _value = SELECTEDVALUE(DimTable[ML])
    RETURN
    IF(
       MAX(MainTable[ML]) IN {_value, _value+1},
       1, 0
    )
     
    choose 1 in the filter pane.
  • 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 }
        )
    )