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.] )
)

     

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

Thanks so much tamerj1 , did you use a formula to add the  [Report Quarter] column for the respective quarters taking into consideration that it is large data. 

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

    hosea_chumba 
     Actually yes. I assumed that this is the case of your model. Otherwise why would you keep them in separate tables and add a new table every new quarter? I know saving one column is a good idea but sometimes you need to do the math. 

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

      You assumed right tamerj1 , how did you add the the [Report Quarter]column for each quarter?

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

        hosea_chumba 

        Actully I did that manually in power powery for each table separately. You can see the code in the sample file.