Slicer graph does not Filter my tables

[Amin_Adham]

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

[Amin_Adham]

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 

[PhilipTreacy]

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

[Amin_Adham]

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 

[v-zhangti · Accepted 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.