Forum Discussion

Amin_Adham's avatar
Amin_Adham
Regular Visitor
3 years ago
Solved

Slicer graph does not Filter my tables

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 ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

     

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
3 years ago

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's avatar
Amin_Adham
Regular Visitor
3 years ago

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's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    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.