Forum Discussion
hosea_chumba
Helper I
Helper IDax 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: ...
Hi hosea_chumba
Please refer to the sample file with the proposed solution https://www.dropbox.com/t/0yKTjmbzDXqrfUv6Weighted 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
Community Champion
Community Championhosea_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_chumbaHelper I
Helper IYou assumed right tamerj1 , how did you add the the [Report Quarter]column for each quarter?
- tamerj1
Actully I did that manually in power powery for each table separately. You can see the code in the sample file.
- hosea_chumba
The formula is not showing, any other way of handling it?
- tamerj1
Ok I'll update the original solution with some screenshots. Just give me some time to open my computer.