topic Re: Need help in DAX Logic in DAX Commands and Tips

Need help in DAX Logic

saurabhtd — Tue, 29 Nov 2022 04:13:20 GMT

I want to do a calculation of DISTINCTCOUNT(TableName[customercode]) of customers from all three countries. But when I select country from countryname filter these conditions should be satisfied.

when countryname = "A" I need to take data from sourcename = "X"
when countryname = "B" I need to take data from sourcename = "X"
when countryname = "C" I need to take data from sourcename = "Z"

There are two filters applied sourcename and countryname.

Note : Customercode,countryname,sourcename are from same table.

I am unable to write required dax to fulfill these conditions. Can someone please help ?

Re: Need help in DAX Logic

FreemanZ — Tue, 29 Nov 2022 04:57:35 GMT

take data from sourcename = "X", then what?

Re: Need help in DAX Logic

saurabhtd — Tue, 29 Nov 2022 05:02:14 GMT

Then calculate DISTINCTCOUNT of customer code

Re: Need help in DAX Logic

tamerj1 — Tue, 29 Nov 2022 08:52:23 GMT

Hi saurabhtd
Please try

= VAR SourceN = SWITCH ( SELECTEDVALUE ( TableName[CountryName] ), "A", "X", "B", "X", "C", "Z" ) RETURN CALCULATE ( DISTINCTCOUNT ( TableName[customercode] ), TableName[SourceName] = SourceN )

Re: Need help in DAX Logic

saurabhtd — Tue, 29 Nov 2022 10:05:46 GMT

Thanks for replying. Now when I select particular country in filter I am getting required answer. But how to get deafult condition which is to calculate distinctcount(customer code) when all the countries 'A','B','C' are selected in the filter. I am strucked at this point now.

Re: Need help in DAX Logic

tamerj1 — Tue, 29 Nov 2022 10:33:29 GMT

saurabhtd
I believe this should be fully dynamic therefore no need for default value.

= VAR SourceN = SELECTCOLUMNS ( VALUES ( TableName[CountryName] ), "@Country", SWITCH ( TableName[CountryName], "A", "X", "B", "X", "C", "Z" ) ) RETURN CALCULATE ( DISTINCTCOUNT ( TableName[customercode] ), TableName[SourceName] IN SourceN )

Re: Need help in DAX Logic

saurabhtd — Tue, 29 Nov 2022 11:13:16 GMT

tamerj1 Thank you again for answering. This is not working. It is giving answer only when country name = "B" and even that answer to is wrong.

Re: Need help in DAX Logic

tamerj1 — Tue, 29 Nov 2022 11:26:54 GMT

saurabhtd
Would you please share a screenshot of your visual?

Re: Need help in DAX Logic

saurabhtd — Tue, 29 Nov 2022 11:36:36 GMT

tamerj1 I need to used it in a card in report of dashboard. Currently I am verfying on new page. what is purpose of "@country" before switch is ? I have not understood this .

Re: Need help in DAX Logic

tamerj1 — Tue, 29 Nov 2022 12:11:35 GMT

saurabhtd
It would be really helpful if you could share a sample file to work with. You can share a download link or send to my email. tamer_juma@yahoo.com

Re: Need help in DAX Logic

Anonymous — Tue, 06 Dec 2022 05:57:11 GMT

Hi saurabhtd ,

Has the problem be solved?

Please consider to mark the reply as solution if it's helpful.