Numeric range slicer from measure

[Anonymous]

Hi all

Does anyone know how to do this with a measure (or a disconnected table with all values of 0-100 in)?

https://docs.microsoft.com/en-us/power-bi/desktop-slicer-numeric-range

Thanks!

[AlB]

Hi @Anonymous

It is explained on the link you provide. What is it exactly that you do not understand or is not working?

[Anonymous]

Hi @AlB

Well it says this CANNOT be done with a measure as the slicer. So is there a way TO do it, like with a disconnected table, or perhaps a summerized table?

Thanks

[v-lili6-msft]

hi, @Anonymous

Measure can't be drag into a slicer in power bi, measure itself is dynamic, This will lead to a circular dependency.

and you could create a relationship between the summarized table with basic table, then you could drag the field in the summarized table into a slicer, and it will affect the basic table too.

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft

Can you please give a simple example (or link to one) where you "could create a relationship between the summarized table with basic table, then you could drag the field in the summarized table into a slicer, and it will affect the basic table too."

Thanks

[v-lili6-msft]

hi, @Anonymous

A simple example:

this is basic data table and this is a summarized Table

basic Tablesummarized Table

then create a relationship between them like this 

Now you could use Column in summarized Table in slicer to filter the data in the basic table.

Best Regards,

Lin

[Anonymous]

But the problem is that the information is being generated by the measure and you can't join tables on a field that is a measure. So this wouldn't work? 

[v-lili6-msft]

hi, @Anonymous

1. Calculation column/table not support dynamic changed based on filter or slicer. (So sum(table[column]) will return fixed value)
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

Measure is a dynamic calculation, when you don't use it in the report, it will be "idle" and without any value.

here is a blog about Calculated Columns and Measures in DAX for you learn:

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Best Regards,

Lin

[Anonymous]

Thanks, I will take a look

[v-lili6-msft]

hi, @Anonymous

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Best Regards,

Lin