Forum Discussion

Shaji's avatar
Shaji
Helper I
6 years ago
Solved

DAX Query

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 ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    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's avatar
amitchandak
Super User
6 years ago

Shaji ,

Try like

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

Shaji's avatar
Shaji
Helper I
6 years ago

amitchandak 

 

 

The result comes as:

Customer Platinum Gold Silver
A              Platinum Gold  No

 

instead of 

 

Customer Platinum Gold Silver
A              Yes           Yes   No