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
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.
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.
Helpful resources
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
