Forum Discussion

keviwilso's avatar
keviwilso
Frequent Visitor
8 years ago
Solved

Weighted average incorrect total

Hi   I am trying to replicate the Weighted ABM calculating defined in the below Excel screenshot in DAX.   Weighted ABM is derived at the Project Level first and then simply aggregated SUM to der...
Need Help
  • keviwilso's avatar
    keviwilso
    8 years ago

    Thanks for the reply.

    The solution was actually just V2_Weighted_ABM measure in the end. at a project level from a user reporting perspective they just want to see the project as sold margin perc and not the weighted one which does not mean anything - it is only used in the aggregation to the visual totals.

     

    With combining them (which is no longer required) I did get that working with using the HASONEVALUE function and checking the project code.

     

    Thanks all for your help and advice with this. It is greatly appreciated.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

keviwilso,


Create measure using DAX below and check if it returns your expected result.

Measure = IF(COUNTROWS(VALUES('project-as-sold-marg-perc'[Project Code]))=1, [V1_Weighting ABM],SUMX(VALUES('project-as-sold-marg-perc'[Project Code]),[V1_Weighting ABM]))



Regards,
Lydia

keviwilso's avatar
keviwilso
Frequent Visitor
8 years ago

Thanks for the reply.

The solution was actually just V2_Weighted_ABM measure in the end. at a project level from a user reporting perspective they just want to see the project as sold margin perc and not the weighted one which does not mean anything - it is only used in the aggregation to the visual totals.

 

With combining them (which is no longer required) I did get that working with using the HASONEVALUE function and checking the project code.

 

Thanks all for your help and advice with this. It is greatly appreciated.