Maximum argument count for ISFILTERED is 1

[Anonymous]

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!

[AlexisOlson]

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?

[Anonymous]

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"

[AlexisOlson]

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

[amitchandak]

@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”)

[Anonymous]

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