Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Unfilter Two Column

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

alanpjames_0-1651234146695.png

Thanks 
Alan

1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

Hi @Anonymous ,

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

vkalyjmsft_1-1651653081022.png

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."

vkalyjmsft_0-1651653022680.png

 

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.

 

View solution in original post

2 REPLIES 2
v-yanjiang-msft
Community Support
Community Support

Hi @Anonymous ,

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

vkalyjmsft_1-1651653081022.png

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."

vkalyjmsft_0-1651653022680.png

 

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
Super User
Super User

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.