Filtering on all pages using a measure - Live Connection

Question

Hello, guys.&nbsp;I'm working with a live connection to a SQL Server Analysis Services database and trying to add a filter on all dashboard pages. The filter would be by the measure "Baseline".&nbsp;I'd like the filter "Baseline&gt;0" applied to all the visuals, but I cannot figure out how to make it work since I can't use a measure in a slicer, and cannot add any new tables to my model or modify the existing ones.&nbsp;Any thoughts?&nbsp;Thank you,&nbsp;Henrique

amitchandak · Answer

Anonymous , Measure can be used as a visual level filter only, You can try dynamic bucketing to make a dimension, but then I measure have to use that bucket 
&nbsp;
Dynamic Segmentation Bucketing Binninghttps://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

anonymous · Answer

Thank you for the response, Amit.The thing is that I cannot upload any data into the model because it is a live connection dashboard, so I cannot create the "Bucket" table.&nbsp;Any other way around?&nbsp;Thx in advance

anonymous · Answer

UP&nbsp;

Forum Discussion

Filtering on all pages using a measure - Live Connection

3 Replies

Related content

Dynamic measure filtering

Filter by Rank measure

Using measure as a filter

Measure not affected by filter

DAX MEASURE TO FILTER