Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Visual filtering

Hi   I have a dashboard built in which there is two slicers on the main page, these slicers control the the filters for all other pages and are synced.  on one page I have two visuals. One is a gr...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.
Nishantjain's avatar
Nishantjain
Continued Contributor
7 years ago
Hi there,

Need a bit more information. Can you share sample data screenshots and what exactly the measure is showing and what you expect to see