Forum Discussion

hosea_chumba's avatar
hosea_chumba
Icon for Helper I rankHelper I
4 years ago
Solved

Dax Equations

Hello fellow community, Kindly help to solve the below problem; Consider the tables below, they are implementation tracking reports for 3 quarters in FY 22. I would like to achieve the following: ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi hosea_chumba 
    Please refer to the sample file with the proposed solution https://www.dropbox.com/t/0yKTjmbzDXqrfUv6

     

    Weighted Implementation = 
DIVIDE (
    SUMX (
        SUMMARIZE ( 
            'Compiled Report', 
            'Compiled Report'[Unique Issue Tracking Ref.], 
            'Compiled Report'[Implementation Status] 
        ),
        CALCULATE ( 
            SELECTEDVALUE ( Weightages[Weight] ), 
            CROSSFILTER ( 'Compiled Report'[Implementation Status], Weightages[Status], Both ) 
        )
    ),
    DISTINCTCOUNT ( 'Compiled Report'[Unique Issue Tracking Ref.] )
)

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi hosea_chumba 
Please refer to the sample file with the proposed solution https://www.dropbox.com/t/0yKTjmbzDXqrfUv6

 

Weighted Implementation = 
DIVIDE (
    SUMX (
        SUMMARIZE ( 
            'Compiled Report', 
            'Compiled Report'[Unique Issue Tracking Ref.], 
            'Compiled Report'[Implementation Status] 
        ),
        CALCULATE ( 
            SELECTEDVALUE ( Weightages[Weight] ), 
            CROSSFILTER ( 'Compiled Report'[Implementation Status], Weightages[Status], Both ) 
        )
    ),
    DISTINCTCOUNT ( 'Compiled Report'[Unique Issue Tracking Ref.] )
)