Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |