DAX Query

[Shaji]

Hi,

For instance I have a table like this:

Customer	Cust ID	Type	Sales
A	11	Platinum	100
A	11	Gold	20
A	11		300
B	12	Silver	200
C	13	Gold	100
C	13	Silver	400
D	14	Platinum	600

Now I need to show in a card or some box the type of Customers:

Eg: If i select a customer name using the select box then ideally my result should be:

Customer	Platinum	Gold	Silver
A	Yes	Yes	No

I belive we should use DAX query to get the result. Please advice

[ryan_mayu · Accepted solution]

@Shaji 

You can create three columns.

Platinum = 
VAR a=countx(FILTER('data',data[customer]=EARLIER(data[customer])&&data[TYPE]="Platinum"),data[customer])
Return if (a>=1, "Yes","No")

Gold = 
VAR a=countx(FILTER('data',data[customer]=EARLIER(data[customer])&&data[TYPE]="Gold"),data[customer])
Return if (a>=1, "Yes","No")

Silver = 
VAR a=countx(FILTER('data',data[customer]=EARLIER(data[customer])&&data[TYPE]="Silver"),data[customer])
Return if (a>=1, "Yes","No")

[amitchandak]

@Shaji ,

Try like

Type measure = coalesce(max(Table[Type]),"No")

[Shaji]

@amitchandak 

This solution works fine with one exception.

The result comes as:

Customer Platinum Gold Silver
A              Platinum Gold  No

instead of 

Customer Platinum Gold Silver
A              Yes           Yes   No