Forum Discussion
sabeensp
7 years agoHelper IV
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...
- 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
TeigeGao
7 years agoSolution Sage
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