Forum Discussion

ppraca's avatar
ppraca
Frequent Visitor
2 years ago

Disconnected table alter the filter context

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 v...
bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

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

 

     TopN_Value = CALCULATE(SELECTEDVALUE('topN'[TopN value]))
ppraca's avatar
ppraca
Frequent Visitor
2 years ago

Thanks for your answer, but doesn't work.