Idea on how to filter records after table has been pivoted and grouped by

[EaglesTony]

I have 2 tables:

DetailTable:

Key            Points    Team          QtrClosed

123           5              TeamA        Q1

456           2              TeamA        Q1

789           1              TeamB         Q2   

999           3              TeamA         Q2

FinalTable:(The source is a reference to DetailTable)

For this table I collapse it to a Team level so it appears as

Team      Points

TeamA    4

TeamB    1

What I want to do, is when a quarter is selected (it is a seperate table with a single column Qtr and "hardcoded" Q1, Q2, etc and a relationship between this QuarterTable and DetailTable(one to many).

If I select Q2(via a slicer), I want to see the following on the FinalTable:(I want to see all quarters if the slicer does not have a selected value):

Team      Points

TeamA    3

TeamB    1

[v-achippa]

Hi @EaglesTony,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Greg_Deckler for addressing the issue.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @EaglesTony,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @EaglesTony,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Greg_Deckler]

@EaglesTony When you say "tables" are these table visuals or calculated tables or ? If we are talking about calculated tables, those are not dynamic based upon slicers and such and so you would need to just use a table visual based upon DetailTable where you would just put Team and Points into the table visual and then everything should work perfectly as you describe.

[EaglesTony]

They are table visuals from a sql source.

[Greg_Deckler · Accepted solution]

@EaglesTony OK, I built a PBIX file. Let me know if it helps. It is attached below signature. If it does not help, I will need to understand what it is not getting correct.