Forum Discussion
Maximum argument count for ISFILTERED is 1
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!
5 Replies
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”)
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?
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"
That doesn't really answer my questions. What text do you want your card to display (and in response to what slicer selections)?
