Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Use slicer from another

Really appreciated it if you can help with this.

I have table A that looks like this

 

CategoryTarget
A2
A12
B11
B23
C23
C11

 

I have created/generated another table "Deviation" from Table A

 

 

Variation = 
VAR MinNumber = FLOOR([X-3σ],.05)
VAR MaxNumber = CEILING([X+3σ],.05)
RETURN
    SELECTCOLUMNS (
        CALENDAR ( MinNumber, MaxNumber ),
        "Deviation", INT ( [Date] )
    )

 

 

 

My problem is - I can connect Table A to Table " Variation" so that I can slice by Category ( example: select only category A - should also change the [deviation] result - Is there a way I can connect my category in table A - i.e [daviation].

 

Thanks in advance

Need Help

8 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Anonymous ,

     

    Try including CATEGORY column from Table A to new Table B. (Add to your SELECTCOLUMNS statement)

    Then create a relationship on this CATEGORY column between these 2 tables.

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks, .. I believe your suggestion will be :

      VAR MinNumber = FLOOR([X-3σ],.05) VAR MaxNumber = CEILING([X+3σ],.05) RETURN SELECTCOLUMNS ( CALENDAR ( MinNumber, MaxNumber ), "Deviation", INT ( [Date] ), ('table A'[catogry] )

       

      • Pragati11's avatar
        Pragati11
        Super User
        5 years ago

        Hi Anonymous ,

         

        Yes. 

        Just try tagging the person in your response. 🙂