topic Re: DAX in DAX Commands and Tips

DAX

Anonymous — Tue, 26 Jan 2021 14:36:39 GMT

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

Re: DAX

amitchandak — Tue, 26 Jan 2021 15:24:56 GMT

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/

Re: DAX

Anonymous — Tue, 26 Jan 2021 17:30:43 GMT

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

Re: DAX

amitchandak — Wed, 27 Jan 2021 08:33:32 GMT

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

or try like

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