Forum Discussion

golandriel's avatar
golandriel
Frequent Visitor
2 years ago

Create a slicer based on a filtered measure

Hi everyone,   I need help creating a slicer based on a filtered measure.   The problem: I have a table with several POI. These POI have bus stops in a specific distance. These bus stops are ran...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi golandriel 

Sorry for the late reply. I missed it earlier. For the second question, we can solve it by modifying our previous solution like below. Create a table to have all possible POI IDs in a column. Connect it to the original table on this POI ID column. 

Then modify the measure like below (+0). This can turn blank to 0 when there is no bus stop, making it able to compare the sum result with the 0 selected from the slicer. 

Measure = IF(SUM('Table POI'[Count])+0=[No. of Bus Stops Value],1,0)

 

For the first question, do you hope to apply the filter to the overall report? If so, the current solution will not work as measures can only be applied to specific visuals as a filter. Measures cannot be used as a page/report level filter. 

 

Best Regards,
Jing

golandriel's avatar
golandriel
Frequent Visitor
2 years ago

Hi Anonymous,

 

thank you for your reply. I haven't solved my problem yet. The answer to my first question should work. 

 

Regarding my first question: Yes, I was hoping that there is a solution to apply my filter on the whole report instead of just specific visuals because I want to apply other filters in followings steps. Maybe I have to think about another solution.

 

Thank you and best regards!