Needed help with passing Variables

Question

DAX USED: SWITCH(SELECTEDVALUE('View By'[Parameter Order]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,RANKX(FILTER(ALLSELECTED(Product[company_name]),NOT(ISBLANK([Sales by Current Month]))),[Sales by Current Month)),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,RANKX(FILTER(ALLSELECTED(Product[BRAND_NAME]),NOT(ISBLANK([Sales by Current Month]))),[Sales by Current Month))&nbsp;In the above mentioned scenerio we are trying to refer different columns(more than five) from same table.&nbsp;In that case, the query checks 5 times for the correct value and then gives the output.so I tried creating a variable and pass it to the 5 columns as field parameter column and use SELECTEDVALUE to retrieve the selected value from the filter.&nbsp;Unfortunately variables are not accepted in certain DAX Functions like SUM and ALLSELECTED.&nbsp;Is there a workaround or a solution for the DAX to be more efficient and improve the performance.

anonymous · Answer

Hi&nbsp;kompalli&nbsp;
After I testing, the sum(), allselected() can support variables
e.g
Measure = SUMX(FILTER(ALLSELECTED('Table (2)'),[CUS]=MAX([CUS])),[value])

Measure 2 = SWITCH(SELECTEDVALUE(Parameter[Parameter Order]),0,RANKX(FILTER(ALLSELECTED('Table (2)'[CUS]),[Measure]&gt;30),[Measure],,ASC,Dense),1,0)
Output:

&nbsp;
Can you provide some detail error message or pbix file, I can offer more help.
&nbsp;
Best Regards!
Yolo Zhu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Related content

pass a dynamic variable from pipeline to notebook

Passing a variable from one pipeline to another

[Data Pipeline] How to pass @pipeline 'Parameters' and 'Variables' to Pipeline Activity

Fabric passing parameter

Passing a Variable not working