cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## 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 ))Return1+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?
2 REPLIES 2
Highlighted
Super User IV

## Re: Counting results of a measure in another measure, for use in a circle diagram

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Highlighted
Frequent Visitor

## Re: Counting results of a measure in another measure, for use in a circle diagram

Hi Greg,

I appreciate your posting, but can you be a little more specific as to where you think i could improve my post (since it, to me, does look like it ticks all the boxes)?

Granted the formatting could be better but for some reason it removed the grind in my table when i posted it