Power BI Measure and Slicer

[Anonymous]

Hello everyone, I want to filter my report. For example; (Count> 80) and I want to use the filter in slicer. For example, show data with (Count> 80). I use sql server as database. I get the queries from sql view. I am using DirectQuery. I have to finish quickly. How can I do that?

[v-eachen-msft]

Hi @Anonymous ,

You could add a new table or What If parameters to create a slicer, but it turns to be a mixed mode.

If you only want to do it in direct query mode, the condition values will be hard coding. Looking forward to a feasible solution.

[Greg_Deckler]

Count of what > 80? Is Count a column with values in it? Is it a measure? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hi, @Greg_Deckler ,

A column with values ​​in count. For example; PieceCount> 80.

[Greg_Deckler]

Hmm, DirectQuery complicates this tremendously. If it was import mode, just create a separate table from 0-MAX(Count) and then a measure, Measure = IF(Count>SELECTEDVALUE('Slicer'[Value]),1,0) and use this measure to filter on equaling 1 for your visual.

DirectQuery, pain and suffering. Have to think about it. Is it OK to create a composite model like this?