Question: I want PowerBi to report to me only the diversity (distinct) groups of each phase.

[samuelhoward]

Question: I want PowerBi to report to me only the diversity (distinct) groups of each phase.

Background: During my evaluation, I did a series of interviews over two phases (conduct and scoping) as show by the data table below. 

Problem: When I slice for 'conduct phase', I want it to report a list of only the DISTINCT/diversity of groups interviewed, which would be:

• LPL
• TYT
• GTG

If I slice for 'scoping phase', I want it to show the DISTINCT/diversity of groups as:

• MRL
• GTG

What I have tried:  I have used the following DAX to create a second table (UniqueL1Table) of these distinct groups, and have it shown as a list, but it can only show as all diversity of both Conduct and Scoping groups....even if I slice for only conduct, it will still show as:

• LPL
• TYT
• GTG
• MRL

UniqueL1Table = Distinct('Combined Tables'[L1])

Data used:

Group	Phase
LPL	Conduct Phase
TYT	Conduct Phase
GTG	Conduct Phase
GTG	Conduct Phase
MRL	Scoping Phase
GTG	Scoping Phase
GTG	Scoping Phase

[lbendlin]

You don't need DAX for that as Power BI automatically aggregates. Put the Group in a table visual and the phase in a slicer.