Forum Discussion
Group By Issues with Filtering
Hi Anonymous
If you want to get a dynamic count of location per Failure Number, build a column(No. of defects) doesn't work.(it's just a count by gourp by Failure Number and result is not dynamic)
We don't need to build a reference table. You can try count function in table visual or build a measure.
I build a sample table like yours.
My table visual is built by Failure Number and Location(select count)
Or Measure:
Measure = COUNT('Main Data'[Failure Number])Build Failure Number and Person slicers. Let's have a test.
Result is as below. We see count function and measure works well but No. of defects(in reference table) shows wrong result.
You can download the pbix file from this link: Group By Issues with Filtering
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak This is as much as I feel I can share. What else would help understand the problem?
Hi Anonymous
If you want to get a dynamic count of location per Failure Number, build a column(No. of defects) doesn't work.(it's just a count by gourp by Failure Number and result is not dynamic)
We don't need to build a reference table. You can try count function in table visual or build a measure.
I build a sample table like yours.
My table visual is built by Failure Number and Location(select count)
Or Measure:
Measure = COUNT('Main Data'[Failure Number])
Build Failure Number and Person slicers. Let's have a test.
Result is as below. We see count function and measure works well but No. of defects(in reference table) shows wrong result.
You can download the pbix file from this link: Group By Issues with Filtering
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.