Filter Power Pivot by the result of a measure

[bela_here]

Hello,

I have a Power Pivot table (see below) that shows the emails reply rate (number treated/number received) for the employees of a company, If they replied to at least 80 % of the emails. the target is reached (YES).
I have created a calculated column that show for each person, service and date if the target was reached and created a slicer out of it. However, it won't do as it calculated at row level.
I have also created a measure that show shows Target Reach = "YES" or "NO".

How can I slice the Power Pivot so when Target Reach is YES it show the date and service who reached the target and the other way around. I have tried using variables but I haven't succeeded.

Can somebody please help?


I am using Microsoft 365.

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:
Filter Power Pivot by the result of a measure

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[bela_here]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:
Filter Power Pivot by the result of a measure

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Thanks and sorry for the cross-post. Except of the link, you provided and this forum, the post is not visible anywhere else now

 

[bela_here]

It was solved
Filter Power Pivot by the result of a measure