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. 

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

        The formula is not showing, any other way of handling it?