Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Reference Table Group By and Filtering

The data set for my Power BI dashboard is used to track products manufactured and defects. Each failure is given a number but within that number there can be multiple defects each unique to a locatio...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

AlB do you think it's in the Many-to-many relationship that is causing the issues.

 

The second table is the raw data where all the variables relating to a failure are stored. This screenshot of the graph I'm using to display the data (filtered) shows what I mean about the wrong count for BOC. 

 

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

If you have group your raw table to ‘reference table' table by failure number. Failure number will be unique in ‘reference table'. And you can create one to many relationship between them. 

 

And did you use No.of Defects column in your ‘reference table' for values in your chart? you need to use measure :

 

 

measure = DISTINTCOUNT('Table'[Location]])

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai