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

Hi, v-yueyunzh-msft ,

 

Thank you very much for the detailed response. It worked as expected on the sample dataset, but unfortunately it does not give the same numbers as the query on the full dataset.

 

vs

 

 

The second image has the correct numbers. If you're unsure what could be causing this I can provide a larger sanitized dataset if you're able to look into this further for me.

 

Thanks!

 

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

Hi , ruiner 

Thanks for your quick response!

I think it may be that there is some difference between my understanding and your needs. This is my undertand for your need:

If there is a problem with my understanding, you can point it out, and for your problem, you can provide me with a little more data, and then provide some detailed calculation process and results.

 

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