Forum Discussion

rocky_puff's avatar
rocky_puff
Frequent Visitor
2 years ago
Solved

Total Overall Value and Individual Value using the same Measure. How to divide them

Hi All.   I'm kind of stuck here. Need your help on this. My problem is the measure used to get defect count and total defect count is the same, to differentiate it is using Plant (a column).  I w...
divide
divide same measure
measure
same
  • lbendlin's avatar
    lbendlin
    2 years ago

    Not sure where you are going with this. Here is the standard approach 

     

     

    But it feels like you need something different?

  • rocky_puff's avatar
    rocky_puff
    2 years ago

    Yaa I think this solved it. I chose different type of ALL previously. 

    DIVIDE(CALCULATE([DefectCount]),CALCULATE([DefectCount],ALLSELECTED(TableABC[ID])))
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Not sure where you are going with this. Here is the standard approach 

 

 

But it feels like you need something different?

rocky_puff's avatar
rocky_puff
Frequent Visitor
2 years ago

Yaa I think this solved it. I chose different type of ALL previously. 

DIVIDE(CALCULATE([DefectCount]),CALCULATE([DefectCount],ALLSELECTED(TableABC[ID])))