Forum Discussion
deb_power123
Helper V
Helper VDelete rows with duplicate entries in table using DAX or Tranformation
Hi, I want to get rid of the rows containing Asia,Delhi then Asia,Shimla and Asia,Panjim as region and location in below table and also it has 100 enties like this[with same combination] . Can w...
deb_power123 , Create a flag like this
if([region] ="Asia" && [Location] in {"Delhi","Shimla","Panjim"} , 1, 0)
You can use that in measure or visual level filter
or create a new table
calculatetable(Table, [Flag]=0)
amitchandak
Super User
Super Userdeb_power123 , Create a flag like this
if([region] ="Asia" && [Location] in {"Delhi","Shimla","Panjim"} , 1, 0)
You can use that in measure or visual level filter
or create a new table
calculatetable(Table, [Flag]=0)
deb_power123Helper V
Helper Vsorry amitchandak My bad it worked,I added wrong name for column.