Forum Discussion

ruiner's avatar
ruiner
Frequent Visitor
3 years ago

Filtering based on parent grouping

I have a table laid out like this:   EmployeeId CompanyId FinancialPeriodId GroupId StatusId 1 10 5 1 1   My visual is grouped by company, financial period and then status. I nee...
Need Help
ruiner's avatar
ruiner
Frequent Visitor
3 years ago

Thanks v-yueyunzh-msft,

 

I have a computed column that combines the composite fk and have set the relationship between the tables manually.

The fields in the slicer are from tables related to the Positions table; they are filtering it correctly because I've added a count field to the visual and it is correct.

 

It is also the only visual at the moment so the only thing I can do with Edit Interactions is turn the slicers off for that one visual.

 

The numbers displayed in the visual are actually a bit lower than expected from the SQL query. I'm not sure that the computed tables are ungrouping by status id and regrouping by employee id correctly.

 

Thanks for the help

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , ruiner

This seems to be a DAX question, can you provide more sample data and then provide us with the result data you ultimately want to get on the visual as tabular form ？

If you're filtering by slicers, you can't use a new table, you need to do so with measures. And if you place some fields on the visual, the calculation occurs in the filtered context of the placed field.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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