Unfilter Two Column

[Anonymous]

Hai, I am New to Dax, Please help to find a solution
I Want two unfilter these two columns(red marked) But unfortunately, I am getting an error please help me

Thanks 
Alan

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

For the ALL function, if the first parameter is a column, you can still add columns as parameters.

But if the first parameter is a table, you can't add other parameters, a error message appears "Multiple table arguments are not allowed in the ALL function."

In your sample, if you want to select all Initiative Type column, don't need to write the table name in front, just quote it directly "ALL('Activity Log'[Initiative Type])".

Additonally, as @amitchandak mentioned, in the CALCULATE function, you can add much filters which separated by commas, not "&&". "&&" is often used when there are multiple filters in the  FILTER function.

CALCULATE(<expression>, <filter1> , <filter2> , …)

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous in place of &&  in line 4, give comma  --> ,