how to change measure value based on selected slicer

[Anonymous]

Hi, 

I have already made my Measures but i need it to change dynamically based on a  slicer.

This are al the calculations.

Total Amount LastMinutes = CALCULATE(COUNT(lastMinutes[Id]));

Total Amount Taken = COUNTAX(FILTER(lastMinute_waitList, lastMinute_waitList[Taken]=TRUE()), [Taken]) + 0;

Total expired LastMinutes = CALCULATE(COUNT(lastMinutes[Id]), FILTER(lastMinutes, lastMinutes[StartsAt] < UTCNOW())) - [Total Amount Taken] + 0;

Total open appoitments = CALCULATE(COUNT(lastMinutes[Id]), FILTER(lastMinutes, lastMinutes[StartsAt] > UTCNOW())) + 0;

this is my slicer.

what needs to happen is that values on dashboard need to change based on what i select.

company names are coming from the companies table

i tried everything but nothing wont change.

Do i soomething wrong.

pls help me out! 😞

[JorgePinho]

Can you show us your data model? Looks like the tables are not connected

[Anonymous]

@JorgePinho 

[JorgePinho]

From which table is the slicer field?

[Anonymous]

companies @JorgePinho 

[JorgePinho · Accepted solution]

So you are trying to filter the tables lastMinutes and lastMinute_waitList with a field from the companies table. However, as you can see the below picture, the relationship marked at red doesn't allow the filter to go to the desired tables...

[Anonymous]

oke thank you i changed all the direction what where needed and now everything works thanks for your help you are a power bi hero