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.
Dear community,
I have a problem that it seems to be quite easy to solve, but I cannot find a good solution for it.
Let’s assume that I have the following table to hold test results of two tests AAA and BBB that runs every day (Test Run and Date):
Test Run | Test Name | Date | Result |
1 | AAA | 1/1/2022 | Pass |
1 | BBB | 1/1/2002 | Fail |
2 | AAA | 2/1/2022 | Pass |
2 | BBB | 2/1/2002 | Pass |
3 | AAA | 3/1/2022 | Fail |
3 | BBB | 3/1/2002 | Fail |
(Obviously the test list host thousands of tests and it runs for many days)
I have a table visual that shows the results of the last run:
Test Name | Result |
AAA | Pass |
BBB | Fail |
When the user will press a test, I would like to show a table that will show all the results of the same test per day.
So, in my example if the user pressed the BBB line I will get the following table:
Test Name | Date | Result |
BBB | 1/1/2002 | Fail |
BBB | 2/1/2002 | Pass |
BBB | 3/1/2002 | Fail |
My problem is that when the user presses BBB I get only the result of the same day and there is no way that I am aware of that allow me to ignore filters in the visual.
Thanks in advanced for the help.
Solved! Go to Solution.
hey @yaronklein ,
Take your base measure that you used to get your first visual, and build a measure on top if it and you can use the ALLSELECTED function.
EDIT: You may need to add your column in the ALLSELECTED, such as:
AllSelected = CALCULATE([BaseResult], ALLSELECTED(YOUR_TABLE[Result]))
Hi @hnguy71 ,
Sorry that it took me some time.
I am ot sure what exactly you mean. it seems that you crated the solution in a smaple pbix. Will you be able to share it?
Thanks.
Hi @yaronklein,
Sorry I haven't been active on the forums due to holiday break.
If you still need a sample, I've attached it here.
Hi @yaronklein ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin Yu
hey @yaronklein ,
Take your base measure that you used to get your first visual, and build a measure on top if it and you can use the ALLSELECTED function.
EDIT: You may need to add your column in the ALLSELECTED, such as:
AllSelected = CALCULATE([BaseResult], ALLSELECTED(YOUR_TABLE[Result]))
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |