Suggestions for creating a measure

[Pragadeesh]

Hi,

I have a sample data as below,

Customer	Opportunity	Status	GUI
A	Development	Lost	X
B	Testing	Closed	X
C	Development	Won	Y
D	Analysis	Open	Y
E	Development	Lost	Z
F	Testing	Closed	Z
G	Analysis	Open	X
A	Testing	Closed	X
B	Analysis	Won	X
C	Development	Open	Y

I have few other visuals which displays the financial numbers for the selected opportunity.

I am looking to create two measures which has to,

1. Show data only for the selected client (I have another dropdown via which I will select a client name)

2. Show data for the selected client and all the other clients in the GUI. For eg, Client A belongs to 'X' GUI and clicking on this should show me the values for all the clients in the 'X' GUI.

Any suggestions for this requirement?

[Greg_Deckler · Accepted solution]

@Pragadeesh Sounds like a Complex Selector: The Complex Selector - Microsoft Fabric Community

See PBIX file attached below signature.

Measure = 
    VAR __SelectedCustomer = SELECTEDVALUE('Customers'[Customer])
    VAR __Customer = MAX('Table'[Customer])
    VAR __Result = IF( __Customer = __SelectedCustomer, 1, 0)
RETURN
    __Result


Measure2 = 
    VAR __SelectedCustomer = SELECTEDVALUE('Customers'[Customer])
    VAR __SelectedGUI = MAXX( FILTER( ALL('Table'), [Customer] = __SelectedCustomer ), [GUI] )
    VAR __GUI = MAX('Table'[GUI])
    VAR __Result = IF( __GUI = __SelectedGUI, 1, 0)
RETURN
    __Result