Forum Discussion

sabeensp's avatar
sabeensp
Helper IV
7 years ago
Solved

Multiple Measure gives same result

Hello,  I have 2 Tables   Fact_Table AgeGroup-- Facility -- Other fields   Dim_Facility Table Facility -- -- Organization   1 Organization has Multiple Facilities - Facility can belong to onl...
  • TeigeGao's avatar
    7 years ago

    Hi sabeensp ,

    In your scenario, we need to create two other tables which only contains Organization and Facility for the slicer, these two tables has no relationship with the original two tables, then we can create the following measures:

    Measure =
    CALCULATE (
        COUNT ( Fact_Table[AgeGroup] ),
        FILTER (
            ALL ( Dim_Facility ),
            Dim_Facility[Facility] IN ALLSELECTED ( Facility[Facility] )
        )
    )
    
    Measure 2 =
    CALCULATE (
        COUNT ( Fact_Table[AgeGroup] ),
        FILTER (
            ALL ( Dim_Facility ),
            Dim_Facility[Organization] IN ALLSELECTED ( Organization[Organization] )
        )
    )

    The result will like below:

    Best Regards,

    Teige