Forum Discussion
Visual filtering
thanks, I did this but it is still ommitting results.
Continued ContributorA synced slicer works exactly the same way as a normal slicer so I expect it to work.
You can also check this by creating a blank page and copy the 2 visuals you have. Make sure you don't sync any slicers. Now sync one slicer at a time and change it's interaction with the 2 visuals and analyse the impact. I am sure you will spot something
I created a new filter, basically there is an issue with where it is pulling the data.
I have two tables both with the ID of Name, I have them both linked to the main data table as a relationship but it appears as though this isn't working correctly
the only reason I hav two tables in the first place is because I can't get a calculation to work in the main employee table. the table has a column for names, but there are two corresponding columns in the main data table. so the relationship that I have is between the Table-Name column and the Data-name1 column. so my second formula which is meant to check the Data-Name2 column, is the one that isn't working.
so I created a whole new table, created the relationship and then the formula worked. but now its not showing the right customer details in the visuals. if I could somehow get the formula to work then I could get rid of the second table and the problem would be solved.
the formula I wrote as a measure is:
Name2 calculation = SUMX(Data,CALCULATE(SUM(Data[Utilisation]),USERELATIONSHIP('Employee List'[Name1 List],Data[Name2 Clean]),FILTER(All('Employee'),'Employee List'[Name1 List]=Data[Name2 Clean])))if you can help me get that one working then I think it will fix the visual issues as well.- NishantjainHi there,
Need a bit more information. Can you share sample data screenshots and what exactly the measure is showing and what you expect to seeI'll put together a sample and add it to this message, I can't do real samples as its confidential data. so will do a mock up