Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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."
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |