Applying a slicer to measure values in a custom table

[Messer185]

So after hours of searching I cannot quite figure this one out.

I have a table of custom values that equal a measure. This table was made as the data points were needed for a funnel and pulling them from the original data set in order seemed difficult. If there is a different way to do this please let me know. 

I want to take a slicer from Iquote Date table and apply it to the values of this table. I would think because all the measures used in the table are from the Iquote Data table that the slicers would work but they do not. Any ideas? Let me know if I need to provide any more info.

[v-shex-msft · Accepted solution]

Hi @Messer185,

Current power bi does not support to create dynamic calculated column/table based on filter selections. They not worked on the same data level so these expressions will be fixed to static values when you use in calculate column/table.

I'd like to suggest you create a custom table with specific category values, then you can write a measure formula to check current table value and selection to redirect to different calculations formulas.

My Favorite DAX Feature: SELECTEDVALUE with SWITCH | Winston-Salem Power BI User Group (pbiusergroup...

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

[mariussve1]

Hi,

If I understand your usecase correct, I think "Field parameter" is what you should use. This can be used with a slicer to choose wich measure you want to show.

I see that "Field parameter" contains almost the same columns as your funnel table. You can also add extra columns, but at the moment naming the extra columns are Fixed and you cant change it. But maybe thats not important 🙂

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

Br

Marius