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 again v-yueyunzh-msft. That wasn't the problem I was looking at yet but that did fix that issue.

 

What is happening is when the slicer is set to fiscal year 2021 the correct totals show

And when set to 2020 the correct totals are also shown

The problem is when both 2020 and 2021 are selected at the same time

The same thing happens when multiple values are selected for other slicers, such as the company slicer.

 

 

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

Hi , ruiner 

It seems the [Measure 2] returns the 11+15 and 26+29 , can you check the summarize() function contains the all columns in your table?

 

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

  • ruiner's avatar
    ruiner
    Frequent Visitor
    3 years ago

    Hi v-yueyunzh-msft,

     

    The original measure also returns the same incorrect numbers when multiple slicer values are selected.