Counting results of a measure in another measure, for use in a circle diagram
I have a made three measures which, when put into a table show the following: Headline Part Completeness Target Reached Target Example RearMirror 75 % 50% Yes Description This is how they are grouped Shows how many cars we have the part on The amount we need the part on, taken from another table Yes/No DaxFormula None Var AntalModeller = [AntalModeller] VAR Vare = CALCULATE( DISTINCTCOUNT(SamVar[K3TYNR]); FILTER(SamVar;SamVar[Vare?] = 1 ) ) Return 1+IF(not ISBLANK(Vare); DIVIDE(Vare - AntalModeller ; AntalModeller ) ) None IF('Gapmeasures'[Completeness] > AVERAGE('Target'[Target]);Yes;No) What i want is to show how many of the parts are on/above target (preferably in a circle), like "5 out of 9" But i can't seem to figure out how to make it calculate the reached target for every target in the same diagram Can anybody help?