topic DAX - Dynamic field parameter according filters in DAX Commands and Tips

DAX - Dynamic field parameter according filters

Kev59 — Fri, 05 Jul 2024 15:23:59 GMT

Dear all

I'm using a field parameter in a segment to change the information shown in my graphs.

My field parameter looks like this:

_Dynamic Herarchy = { ("Market Segment", NAMEOF('CDD - Account Grouping'[Market Segment]),1), ("Customer Grouping", NAMEOF('CDD - Account Grouping'[CDD EU Customer Grouping]),2), ("Sold-To", NAMEOF('CDD - Account Grouping'[Sold To & Name]),3), ("Ship-To", NAMEOF('CDD - Invoiced Sales'[Ship To & Name]),4), ("BU",NAMEOF('Products'[BU]),5), ("Product Grouping",NAMEOF('Products'[Division Reporting Group Name]),6), ("Product",NAMEOF('Products'[Product]),7), ("Batch",NAMEOF('CDD - Invoiced Sales'[Batch]),8), ("Posting Date",NAMEOF('CDD - Invoiced Sales'[Posting Date]),9), ("Invoice Number", NAMEOF('CDD - Invoiced Sales'[Invoice Number]),10) }

Is there a way to make it dynamic according the filters?

For example, if a filter is set on the "Market Segment", I would like to hide this option in the field parameter. And do the same for all parameters included in my field.

Is it possible to do someting like this?

Thanks in advance for your help

Re: DAX - Dynamic field parameter according filters

lbendlin — Sat, 06 Jul 2024 17:41:21 GMT

For example, if a filter is set on the "Market Segment", I would like to hide this option in the field parameter.

Why? These concepts are independent of each other. One is working on data level, the other on meta data level.

Re: DAX - Dynamic field parameter according filters

Kev59 — Mon, 08 Jul 2024 07:41:52 GMT

Hi lbendlin

I have some segments used as global page filters but I use field paramaters to adapt to data shown in a matrix for example.

And If I have set a global filter on a specific region or country for example, I don't need to have this option available in my field parameter...

That's why I would like to link both "filtering".

Feasible?

Re: DAX - Dynamic field parameter according filters

lbendlin — Mon, 08 Jul 2024 13:17:30 GMT

Is this something your users asked for?

Re: DAX - Dynamic field parameter according filters

Kev59 — Mon, 08 Jul 2024 14:09:20 GMT

Yes

For better clarity of the matrixes and to have field parameters with fewer options when global filters are used.

so, what I would do is feasible or not? Can I use IF function to create a modulable field parameters? Where can I find example?

Many thanks in advance for any help

ps: I know it's not a common request 😉

Re: DAX - Dynamic field parameter according filters

lbendlin — Mon, 08 Jul 2024 15:00:34 GMT

Enable "Personalize Visuals" and teach your report users how to use that feature.

Re: DAX - Dynamic field parameter according filters

Kev59 — Mon, 08 Jul 2024 15:10:55 GMT

Sorry to say that but that doesn't answer my question: feasible or not.

And your solution is impossible in my case because the filters are inactivated on my report. Users use segments to filter my report pages (see below).

Re: DAX - Dynamic field parameter according filters

lbendlin — Mon, 08 Jul 2024 15:19:58 GMT

I see. I respectfully disagree with your design choices and will retire from this thread. I hope someone else can help you further.

Re: DAX - Dynamic field parameter according filters

Kev59 — Mon, 08 Jul 2024 15:24:33 GMT

no worry 😉

thanks

Re: DAX - Dynamic field parameter according filters

Kev59 — Tue, 09 Jul 2024 12:52:49 GMT

Hi all

would something like this work?

_Dynamc Hierarchy = VAR _FilterMarket = IF(ISFILTERED ( 'CDD - Account Grouping'[Market Segment] ),- 1,1) VAR _FilterGrouping = IF(ISFILTERED ( 'CDD - Account Grouping'[CDD EU Customer Grouping] ),- 1,1) RETURN { ("Market Segment", NAMEOF('CDD - Account Grouping'[Market Segment]),_FilterMarket), ("Customer Grouping", NAMEOF('CDD - Account Grouping'[CDD EU Customer Grouping]),_FilterGrouping), ("Sold-To", NAMEOF('CDD - Account Grouping'[Sold To & Name]),3), ("Ship-To", NAMEOF('CDD - Invoiced Sales'[Ship To & Name]),4), ("BU",NAMEOF('Products'[BU]),5), ("Product Grouping",NAMEOF('Products'[Division Reporting Group Name]),6), ("Product",NAMEOF('Products'[Product]),7), ("Batch",NAMEOF('CDD - Invoiced Sales'[Batch]),8), ("Posting Date",NAMEOF('CDD - Invoiced Sales'[Posting Date]),9), ("Invoice Number", NAMEOF('CDD - Invoiced Sales'[Invoice Number]),10) }

And apply a filter on the segment?