Forum Discussion

FeroSK's avatar
FeroSK
Frequent Visitor
3 years ago

AverageX with dynamic denominator

Hi Friends   My snowflake data model contains many-to-many relationships This is intentional because I want to use multiple values from the fact table to calculate separate indicators. I ne...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

FeroSK One thought, try DISTINCT vs VALUES

FeroSK's avatar
FeroSK
Frequent Visitor
3 years ago

Sorry, did not help. Problem is in this denominator part:

            var _denominator = 
                LOOKUPVALUE( 
                    'Indicator Details'[Denominator], 
                    'Indicator Details'[Denominator], 
                    SELECTEDVALUE( 'Indicator Details'[Denominator] ) 
                )
            var _denominatorValue = 
               SWITCH( 
                TRUE(),
                _denominator = "Measure A", [Denominator 1],
                _denominator = "Measure B", [Denominator 2],
                _denominator = "Measure C", [Denominator 3]
               )
            return
            _denominatorValue