Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Contribution calculation not correct

I have a simple data model,

the tables are like below

And I created measures as follows:

loan% = Divide( Sum(LandBuildCost[loan%]), 100)

LandBuildCostAmount = Sum(LandBuildCost[LandBuildCost])

Contribution = LandBuildCostAmount * loan%

No of Applicant = Count(Applicants[ID])

but when I place the measure on a table the contribution is not correct

the contribution should be less than the LandBuildCostAmount.

But when filter of applicant ID is applied i works.

How can i calculate to avoid filter/slicer usage. 

Also, loan% total is 150%, how to stop loan % total from appearing.

Thanks

  • Anonymous , Change this measure and try

    Contribution = Sumx( LandBuildCost, LandBuildCost[LandBuildCost]*LandBuildCost[loan%]/100.0)

     

1 Reply

  • Anonymous , Change this measure and try

    Contribution = Sumx( LandBuildCost, LandBuildCost[LandBuildCost]*LandBuildCost[loan%]/100.0)