locked
Relationship issue RRS feed

  • Question

  • Hi All

    My issue is the slicer dosn't change my PivotTable.

    Simplified model looks like this:

    I need to slice my Table MAPPING to get desired result in my Pivot Table. 

    One of the difficulties is in Table MAPPING includes some  duplicates i.e:

    table MAPPING

    SPREAD             SPREAD MAPPPING

    1                               1

    2                              3

    3                              3

    4                              5

    ...                            ...

    So thats why I created table BRIDGE with unique Spreads

    Is there workaround how tu use slicer in this case?




    Thursday, October 8, 2015 8:50 AM

Answers

  • For a slicer to have an effect through a bridge table, the measures need to be written appropriately.

    M2M Measure:=
    CALCULATE(
        [Measure from fact table]
        ,'Bridge Table Name'
    )

    This will allow you to slice based on the table from the other side of the bridge from the fact.

    Here are some more resources on utilizing a many-to-many relationship in DAX:

    https://sqlbits.com/Sessions/Event9/Many-to-Many_Relationships_in_DAX

    http://www.powerpivotpro.com/2012/11/a-mystifying-and-awesome-solution-for-many-2-many/

    https://www.sqlbi.com/articles/optimize-many-to-many-calculation-in-dax-with-summarize-and-cross-table-filtering/

    http://www.sqlbi.com/articles/many2many/

    GNet Group BI Consultant

    Thursday, October 8, 2015 2:40 PM