how to pass the Dynamic parameters to the Dax Quary

[Anonymous]

Hi Team,..

I am strucked in the passing parameters to the dax quary.... please help me on this

I ceraed the table  by useing the below dax code  

Table 2 = SUMMARIZECOLUMNS('Brand'[Brand], 'Fact Table'[Index],

FILTER(VALUES('Brand'[Brand]), ('Brand'[Brand] = "thumsup") || ('Brand'[Brand] = "6up")), FILTER(VALUES('Gender'[gender]), ('Gender'[gender] = "Male only")), "RANKmeasure", [RANKmeasure], "Max", [Max], "N", [N], "Min", [Min], "Countmeasure", [Countmeasure], "Measurepercent", [Measurepercent],"Dimension", [Dimensiontest])

I need to pass the parameters by dynamically. means here brand is thumsup and 6up is selected but i need to select  that dynamically  by the user. we tried selectedvalue like , 

FILTER(VALUES('Gender'[gender]=SELECTEDVALUE('Gender'[gender])


but not working as per the requirement....

please help me on this 

[v-chuncz-msft · Accepted solution]

@Anonymous ,

Values in a calculated table are fixed. You may create a measure and take a look at this post.