Use slicer from another

[Anonymous]

Really appreciated it if you can help with this.

I have table A that looks like this

Category	Target
A	2
A	12
B	11
B	23
C	23
C	11

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

[Pragati11]

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]

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] )

[Anonymous]

To make it more clear : You will get the same result [ daviation] if you make a selection. 

[Pragati11]

Hi @Anonymous ,

Can you tell me what's the logic behind the following part of your DAX:

SELECTCOLUMNS (
        CALENDAR ( MinNumber, MaxNumber ),
        "Deviation", INT ( [Date] )
    )

I don't understand why a new table is created. It's just measures and you could have done them in TABLE1 itself.

[Anonymous]

Hi,

Thank you. This is like GENERATESERIES FUNCTION The idea is to create a bell-curved shape for each category ( by using other measures) - Now, we can create if we split the sample data by category, but the real data has a lot of categories ( will be tough to do that). So everything else will work except how we can generate by category

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

[Pragati11]

Hi @Anonymous ,

Can't you do this in the existing TABLE1 as it uses measures from TABLE1?

[Anonymous]

If We Can we generate X without creating another table? I don't know that

[Pragati11]

Hi @Anonymous ,

Yes. 

Just try tagging the person in your response. 🙂