Forum Discussion
Slicer graph does not Filter my tables
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 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
Community SupportHi, 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.