Forum Discussion
Filtering Measure using a Slicer
Good Morning!
I'm looking to see if theres a way that I can filter a measure using a slicer so that the measure only takes into account what is actually visible on the screen instead of just looking at all the background data. Heres my example:
Here I have a status report with 2 date filters and some measures in the table. The first measure is TotalCurrentQty = CALCULATE(SUMX(currentQty,currentQty[ReelQty]),USERELATIONSHIP(BalanceQuery[Owner],currentQty[cqOwner]))
Which all it does is sum up a quantity where the Owners of the 2 queries are the same. The next is
Is this even a possibility? I've tried ISSELECTED and still didn't get accurate results. Thanks in advance!
Hi Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
2 Replies
- v-piga-msftResident Rockstar
Hi Anonymous ,
To understand your scenario, you'd better share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry
- v-piga-msftResident Rockstar
Hi Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry