Dynamic Measure

[amaleranda]

Hello DAX Gurus, 

I need a little help. 

I have a report including below graph with some other visuals. What I need is to show % in card visual. By defaults (when user didn't select anyting on the graph card needs to show the current % in this case 28% (20W11-14). issue is when I put the same measure it does show the current % it showed average of all, which is default behaviour of dax.

say someone seleted 19W36-39 the card should change to 86%. 

the mesaure for % in the graph as below. is there a way to achieve this.

Compliant% = DIVIDE(

CALCULATE(

DISTINCTCOUNT(Schedule_[Work Order]),

Schedule_[Status] = "Compliant"

),

DISTINCTCOUNT(Schedule_[Work Order])

)

[Greg_Deckler · Accepted solution]

Well, you could do this:

Card Compliant% = 
  VAR __YearWeekThingInAxis = MAX('Table'[YearWeekThingInAxis])
RETURN
  CALCULATE([Compliant%],FILTER('Table',[YearWeekThingInAxis] = __YearWeekThingInAxis))

Assumes quite a few things. 

[amaleranda]

@Greg_Deckler   Your assumptions were correct 🙂 Thanks mate. Champion.

[Greg_Deckler]

Sweet! 🙂

[amitchandak]

It should work with filter . Can you share sample data and sample output.