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 ,

 

It was actually a problem with my slicers that I have fixed. I am still having a problem however. When multiple selections are present on the slicers the totals are cumulative instead of being per group.

 

 

Do you have any ideas how to correct this?

 

Thanks for your help!

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

Hi , ruiner 

If you want the "total" show right, you can create a new measure based on the before, like this:

Measure 2 = var _t =  ADDCOLUMNS(SUMMARIZE(ALLSELECTED('Query1'),'Query1'[CompanyId],'Query1'[FiscalPeriodId],'Query1'[EmployeeStatusId]),"measure",[Measure])
return
IF(HASONEVALUE('Query1'[EmployeeStatusId]),[Measure],SUMX(_t,[measure]))

Then you can test in the visual :

 

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