topic Re: Need help with DAX code, performance problem in DAX Commands and Tips

Need help with DAX code, performance problem

Anonymous — Tue, 05 Jan 2021 15:14:38 GMT

See the description of the problem below, "Metric_to_Show" in the red box.
As you can see I have one solution that is working fast if I use the actual metric,
but when I replace the actual metric with my dynamic selection it is slow.

So my Q is why is it not working with ’Dynamic_Metrics’[Metric to show]?

Re: Need help with DAX code, performance problem

AlB — Tue, 05 Jan 2021 16:38:49 GMT

Hi Anonymous

Can you share the pbix? Otherwise:

Can you show the code for [Selected Metric Name]?

Can you show where you are using the measure (what visual, what fields are in the visual and the relevant tables)?

What exactly do you mean by "keep my filters"?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

Re: Need help with DAX code, performance problem

Anonymous — Tue, 05 Jan 2021 21:50:05 GMT

Sorry, I can't share the pbix.
The model is build in SSAS also.
But I can share the code 😃
Selected Metric Name:= SELECTEDVALUE(Dynamic_Metrics[Metric Name], "No selected")

And I select the Metric Name from a slicer in the pbix.

Re: Need help with DAX code, performance problem

Anonymous — Wed, 13 Jan 2021 07:55:31 GMT

I have created a testfile, but I can't find how to upload it here. Do you know how to do that?

Re: Need help with DAX code, performance problem

AlB — Wed, 13 Jan 2021 07:57:48 GMT

Anonymous

You have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).

Re: Need help with DAX code, performance problem

Anonymous — Wed, 13 Jan 2021 15:46:11 GMT

I have found the problem in the switch statement.
After changing the switch statement to this, it is working.
Metric to show:=
SWITCH(
SELECTEDVALUE(Dynamic_Metrics[Metric Name], "All/No selected"),
"# of rows with Police dispatched by",[# of rows with Police dispatched by],
"# of rows with Fire dispatched by",[# of rows with Fire dispatched by],
"# of rows with Guard dispatched by",[# of rows with Guard dispatched by],
"# of rows with Guard dispatched cancelled by",[# of rows with Guard dispatched cancelled by],
"# of rows with Sms sent by",[# of rows with Sms sent by],
"# of rows with First ACK by",[# of rows with First ACK by],
[# of rows with Guard dispatched by]
)