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 looking for advice on an issue (I'm new to Power BI). I have data that is used for benchmarking. The relevant table contains both the data to be benchmarked (dataA) and the data against which it will be benchmarked (dataB).
To separate the data so that dataA is not included in dataB, as it's not good practice to include the data to be benchmarked in the data that it will be benchmarked against, I have created a virtual table that is filtered by a measure [Active Org]. The measure is controlled by a slicer that selects the client allowing us to see their data (dataA) in comparison with dataB.
This virtual table it relatively straightforward:
Solved! Go to Solution.
calculated table is not supposed to be responsive to the slicer. I would suggest you simplify your report, upload your pbix file here and let us see how it could be solved.
calculated table is not supposed to be responsive to the slicer. I would suggest you simplify your report, upload your pbix file here and let us see how it could be solved.
thank you very much - I'm not oging to upload the pbix, but I take your point and advice.
thank you - unfortunately that doesn't work
You could try this:
VirtualTable2 = filter(DataTable,NOT(DataTable[OrgID] = [Active Org]))
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 |
---|---|
40 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |