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
Super User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

rocky_puff's avatar
rocky_puff
Frequent Visitor
2 years ago

ID

Defect Count

Defect Count Weightage

A

767,212

0.3848

B

504,089

0.2528

C

722,384

0.3623

Total

1,993,685