topic Re: Creating a Dimension that is dependent on Parameter Selected in DAX Commands and Tips

Creating a Dimension that is dependent on Parameter Selected

EACruz — Sat, 01 Feb 2025 01:01:19 GMT

Hello,
I am transitioning from Tableau to Power BI and am Struggling finding DAX Expressions that allow the rows/columns in a Matrix to adjust based on the parameter selection. In Tableau this was a simple task because I could just write the calculated field below.

Aging Days

if [Aging Parameter] = "DOS Aging" Then [DOS Aging]

elseif [Aging Parameter] = "Denial Aging" then [Denial Aging]

END

Aging Group

CASE [Aging Days]

WHEN "000 - 030" THEN "000 - 090"

WHEN "031 - 060" THEN "000 - 090"

WHEN "061 - 090" THEN "000 - 090"

ELSE "091 +"

END

How can I create a new Column that groups the days based on the Parameter Selection in a Matrix? No Matter which Aging Parameter is selected the Grouping is the same but the Aging Days will vary based on which selection is made (DOS or Denials).

Thank You in advance for your help!

Re: Creating a Dimension that is dependent on Parameter Selected

lbendlin — Sat, 01 Feb 2025 01:48:18 GMT

read about Field Parameters, that's the closest you can get to that.

Use report readers to change visuals (preview) - Power BI | Microsoft Learn

Re: Creating a Dimension that is dependent on Parameter Selected

rohit1991 — Sat, 01 Feb 2025 12:09:08 GMT

Hi, EACruz ,
Here's how to achieve dynamic aging groups in Power BI using DAX:

Create a Parameter Table (Disconnected Table) : AgingParameter = DATATABLE("Aging Selection", STRING, { "DOS Aging", "Denial Aging" })
Capture Selected Parameter:
SelectedAging = SELECTEDVALUE(AgingParameter[Aging Selection], "DOS Aging")
Define Aging Days Based on Selection:
AgingDays = SWITCH([SelectedAging], "DOS Aging", SELECTEDVALUE('YourTable'[DOS Aging]), "Denial Aging", SELECTEDVALUE('YourTable'[Denial Aging]))
Create Aging Group Logic: AgingGroup:
AgingGroup = SWITCH(TRUE(), [AgingDays] IN {"000 - 030", "031 - 060", "061 - 090"}, "000 - 090","091 +")
Use in Matrix Visual
- Place AgingGroup in Rows.
- Use measure values in Values.
- Add AgingParameter[Aging Selection] as a slicer.

Re: Creating a Dimension that is dependent on Parameter Selected

EACruz — Wed, 05 Feb 2025 01:20:31 GMT

Hi rohit1991 ,
I appreciate the detailed explanation! I was able to reacreate all of the Fields as you mentioned above.

The only challenge with 'Aging Days' is that if we use the SELECTEDVALUE function then we are expecting to see One Distinct Value but as shown below 'DOS Aging' and 'Denial Aging' has a list of Values. I wanted to use it as a Dimension to toggle between one and the other without the addition of another Parameter. In other words, 'Aging Selection' should allow me to switch between 'DOS Aging' and 'Denial Aging' Dimensions.