topic Re: Disconnected table alter the filter context in DAX Commands and Tips

Disconnected table alter the filter context

ppraca — Thu, 25 Jul 2024 09:50:12 GMT

Hi,

I'm working in an Excel Pivot table, and I have a disconnect table: TopN value.

My model:

In the disconnected table I have the following measure: TopN_Value= =SELECTEDVALUE('topN'[TopN value])

In the following filter context everything is ok:

But when I drag the TopN_Value measure to the table, it ignore the filter context, and list all the row values for "TARIFA". I think this not happen in Power Bi.

Thanks,

Paulo Praça

Re: Disconnected table alter the filter context

bhanu_gautam — Thu, 25 Jul 2024 10:07:14 GMT

ppraca ,You might need to use the CALCULATE function to modify the filter context explicitly.

TopN_Value = CALCULATE(SELECTEDVALUE('topN'[TopN value]))

Re: Disconnected table alter the filter context

ppraca — Thu, 25 Jul 2024 10:14:58 GMT

Thanks for your answer, but doesn't work.

Re: Disconnected table alter the filter context

shafiz_p — Thu, 25 Jul 2024 16:12:42 GMT

Hi ppraca As I can understand that, you want to sum the top N value as chosen by the user from the disconnected table. If this is the case, you have to integrate selected value of TopN to your sum measure. Create sum measure to solve the problem :

SumConsumo =
VAR TopN_Value = SelectedValue(TopN[TopN_Value])

VAR _Result = Sumx(TOPN(TopN_Value, YourTable, [Value]), [Value])

Return
_Result

This measure will first select top N value as chosen by the user from the disconnected table, and then sum up the corresponding values. Please adjust the table and column names accordingly.

Hope this helps!!

If this solved your problem, please mark it as a solution!!