cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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:

HeadlinePartCompletenessTargetReached Target
ExampleRearMirror75 % 50%Yes
DescriptionThis is how they are groupedShows how many cars we have the part onThe amount we need the part on, taken from another tableYes/No
DaxFormulaNone
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?
2 REPLIES 2
Highlighted
Super User IV
Super User IV

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

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


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

Putting square pegs in round holes since 1972.

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




Did I answer your question? Mark my post as a solution!

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

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.