topic Re: Model Relationship vs SWITCH vs Custom Matrix. in DAX Commands and Tips

Model Relationship vs SWITCH vs Custom Matrix.

Anonymous — Tue, 06 Apr 2021 13:42:28 GMT

Hello All,
This time I have following issue...

For the following funcions and following model funcion SWITCH works well

BUT for the following model and following funcions SWITCH doesn't work.

I would like to understand what is the logic behind in one case (model without ralationship) I can assign sum of two values to Gross margin label but in other case (model with relationship) I can't?
How to upragre my DAX to resolve this issue?

Thank you in advance fo your reply.
Thank

Re: Model Relationship vs SWITCH vs Custom Matrix.

amitchandak — Tue, 06 Apr 2021 14:34:13 GMT

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Also

In the second case in Switch replace selectedvalue with Max and text once.

Re: Model Relationship vs SWITCH vs Custom Matrix.

Anonymous — Wed, 07 Apr 2021 09:30:25 GMT

Hi,
there is pbx file
https://drive.google.com/drive/folders/1foPUnS13r7KeZsLDHOiU6JsOk5npvWci?usp=sharing

i have changed the scenario like following

but issue is the same,
I can't make mathematical calculation and switch to France + Germany,
Switch funcion works only for txt message.

Thank you in advance for your reply how to solve this issue.

Re: Model Relationship vs SWITCH vs Custom Matrix.

Anonymous — Wed, 07 Apr 2021 18:02:07 GMT

Anonymous

It's easy to explain the behaviour if you know how filters interplay with CALCULATE, especially nested CALCULATE's.

In the first example, the table 'Admin Categories' does not filter anything, even if you put its columns in a visual; hence you can see values. In the second example, 'Admin List' filters 'Admin Account'. Now, if you put a column from 'Admin List' in a visual, 'Admin Account' gets cross-filtered and the filter is "Gross Margin Level..." Hence, only rows which join to this value are visible in the current context. Since your measures [1] and [2] filter (in their definition) on the field 'Admin Account'[Level 1] and the values you want to filter by have been eliminated by the filter coming from 'Admin List'... well, therefore blank is returned.

Re: Model Relationship vs SWITCH vs Custom Matrix.

Anonymous — Thu, 08 Apr 2021 08:28:26 GMT

Anonymous
Beautiful!
Thank you very much!
Now I understand more

Filter - ALL('ADMIN List')) solved my doubts.
Best!