topic Maximum argument count for ISFILTERED is 1 in DAX Commands and Tips

Maximum argument count for ISFILTERED is 1

Anonymous — Fri, 19 Nov 2021 17:05:33 GMT

Hello!

I'm trying to replicate this filter selection card: https://p3adaptive.com/2018/02/using-selectedvalues-capture-power-bi-slicer-selections/ but putting two different columns from two different tables in a same "filter identifier visual card"

To do this, I need to modify the following function:

Employee Sales Region Selection = IF( ISFILTERED(‘Employee Details'[Employee Team Name]), CONCATENATEX(VALUES (‘Employee Details'[Employee Team Name]), [Employee Team Name], “,”), “No Selection”)

My idea is that instead of a single column (‘Employee Details'[Employee Team Name]), two different columns are attached in this function (‘Employee Details'[Employee Team Name], ‘Expense Ratio'[Expense Ratio])

Regards and Thanks!

Re: Maximum argument count for ISFILTERED is 1

amitchandak — Fri, 19 Nov 2021 16:09:11 GMT

Anonymous , I hope this is meausre

Employee Sales Region Selection = IF( ISFILTERED(‘Employee Details'[Employee Team Name]), CONCATENATEX(VALUES ‘Employee Details'[Employee Team Name], “,”), “No Selection”)

You can try like

Employee Sales Region Selection = IF( ISFILTERED(‘Employee Details'[Employee Team Name]), CONCATENATEX(VALUES ‘Employee Details'[Employee Team Name] & " " " & ‘Expense Ratio'[Expense Ratio], “,”), “No Selection”)

Re: Maximum argument count for ISFILTERED is 1

Anonymous — Fri, 19 Nov 2021 16:22:02 GMT

Unfortunately it has not worked.
Now the problem is: "Too many arguments were passes to the VALUES function. The maximum argument count for the function is 1."

Re: Maximum argument count for ISFILTERED is 1

AlexisOlson — Fri, 19 Nov 2021 16:31:26 GMT

It's not clear what your goal is. Are you trying to check if both columns are filtered? What do you want your measure to output?

Re: Maximum argument count for ISFILTERED is 1

Anonymous — Fri, 19 Nov 2021 17:03:15 GMT

I'm trying to replicate this filter selection card: https://p3adaptive.com/2018/02/using-selectedvalues-capture-power-bi-slicer-selections/

But putting two different columns from two different tables in a same "filter identifier visual card"

Re: Maximum argument count for ISFILTERED is 1

AlexisOlson — Fri, 19 Nov 2021 17:22:06 GMT

That doesn't really answer my questions. What text do you want your card to display (and in response to what slicer selections)?