The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Dear All.
Good Day.
I have created a calculated measures and when I use it in my table, it looks fine.
It is the allocated expense for project and in my table it filters the projects correctly and looks nice.
But when I use slicer option to choose an specific project code, it stops filtering and the data disappears.
Why?
wht is the difference of slicer with table that one can filter my measure while another can't.
I used the same field "project code" for both visuals and checked it.
here is two pictures. first the table without slicer, second the table with slicer which is not working.
I'd be happy to hear your advice.
Regards,
Amin Khaghani
Solved! Go to Solution.
Hi, @Amin_Adham
You can try the following methods.
Measure = [Percent of Total]*CALCULATE([Overhead],ALL('00- JV List'),ALL('01- Project Hours'))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Dear v-zhangti and many thanks for the help.
I entered the mentioned formula in my original report and it's now working fine.
THanks
Hi @Amin_Adham
Looking at your images, it appears that the slicer is working correctly, assuming that there is no data associated with the Project Code -1987.
I'm not sure what you expect to see when the code -1987 is selected?
Hard to give you any other advice without seeing your PBIX file - please provide a copy with anonymized data if the data is sensitive.
Regards
Phil
Proud to be a Super User!
Hi Dear Philip.
Hope you are doing well and many thanks for your time and responde.
I have created a test sample with all fake data and have attached for your kind attention.
Please refer to the last sheet, named: "Test".
There you can see that I have a Project list that each have it's allocated Overhead expenses.
beside I added an slicer to filter any specific project. but when I choose a project code, the calculations and filters disappera.
For sure, they have data and I checked.
for example: Project 1281 hase an overhead amount of 150 M, but when clicking on Project 1281 in slicer, It disappears.
I have copied the download link for the pbix file.
https://www.dropbox.com/s/m9ounkccidtripc/01-%20Allocation%20Test.pbix?dl=0
Please check and advise.
Best Regards,
Amin
Hi, @Amin_Adham
You can try the following methods.
Measure = [Percent of Total]*CALCULATE([Overhead],ALL('00- JV List'),ALL('01- Project Hours'))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
79 | |
78 | |
39 | |
36 |
User | Count |
---|---|
158 | |
111 | |
64 | |
59 | |
54 |