Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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)?
@macarenagc , 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”)
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."
User | Count |
---|---|
59 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |