DAX

[Anonymous]

Hi Everyone 
   when i am single select  UAE Country in that slicer it will show only Country Wise Amount. but am multiple select on that slicer ( more Country )it will show only conversion amount. so how to do that?. please sort me out

[amitchandak]

@Anonymous , I doubt you can add a column based on the number of values of selection.

You can make the conversion amount blank using is filtered and hasonevalue

https://www.youtube.com/watch?v=hXg3kRFSGjAhttps://www.youtube.com/watch?v=hXg3kRFSGjA

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[Anonymous]

Hi 
  Am trying this way but this is not working. if i click on that two country i want total appreal sales but it showing total apperal store. so it's not working 

[amitchandak]

@Anonymous , check what is value you are getting for distinctcount([country_name])

or try like

if( distinctcount([country_name]) >1, [meaure1] , [measure 2])