How do I create a measure to sum (total) up a distinct count?

[kldefens]

Hi guys,

As you can see in the picture down below I created a table with different colums:

• First column [VullingTotaalPerc] shows the percentage of version ID that are filled 100% and so on
• Second column [Count of Versies.Id] shows the count (distinct) of the total version ID.
• Third column [TotalVersiesIDCalculate] is a measure that I created that shows the count (distinct) of the total version ID but only for department X.
  Measure = TotalVersiesidCalculate = calculate(DISTINCTCOUNT(MKA[Versies.Id]),MKA[ProductieAfdeling]="COC2 en I&V")
• Fourth column [DistinccountVersies.id-Calculated] is a measure that I created that show the count (distinct) of versies.ID.
  
  DistinccountVersies.id-Calculated = DISTINCTCOUNT(MKA[Versies.Id])
• Fifth column [COC2-Calculated] is a measure that I created  -  [TotalVersiesIDCalculate] divided by [DistinccountVersies.id-Calculated] to show what the percentage is of the total amount.

The problem now is that when I use this formula: [TotalVersiesIDCalculate] / [DistinccountVersies.id-Calculated] the measure will divide 8 with 56 but what I want is that 8 will be divided by the total of 2533.

Can anyone help me out here?

Thnx!

[amitchandak · Accepted solution]

@kldefens , Try like

Divide([TotalVersiesIDCalculate], calculate([DistinccountVersies.id-Calculated], allselected()) )