Forum Discussion

Pp110784's avatar
Pp110784
Helper II
1 year ago
Solved

Web URL not working with dax switch formula

I have a PBI report using a matrix visual. I want to add another column to it which has URL values. I have the URLs to be displayed in a column (plan_5500_link). The data category for this column has...
Need Help
  • Pp110784's avatar
    Pp110784
    1 year ago

    I changed your formula a bit & got it to work 🙂

    Plan 5500 link =
VAR CurrentPlanNameGrp = SELECTEDVALUE(ABTTableData[PLAN_NAME_GRP])
IF (
    ISINSCOPE ( 'ABTTableData'[PLAN_NAME_GRP] )
        && NOT ISINSCOPE ( 'ABTTableData'[INVESTMENT_NAME2] ),
    CALCULATE(MAX ( 'ABTTableData'[plan_5500_link] ),ABTTableData[PLAN_NAME_GRP] = CurrentPlanNameGrp), BLANK()
)

     

    Thank you so much for your help MFelix 

Pp110784's avatar
Pp110784
Helper II
1 year ago

I changed your formula a bit & got it to work 🙂

Plan 5500 link =
VAR CurrentPlanNameGrp = SELECTEDVALUE(ABTTableData[PLAN_NAME_GRP])
IF (
    ISINSCOPE ( 'ABTTableData'[PLAN_NAME_GRP] )
        && NOT ISINSCOPE ( 'ABTTableData'[INVESTMENT_NAME2] ),
    CALCULATE(MAX ( 'ABTTableData'[plan_5500_link] ),ABTTableData[PLAN_NAME_GRP] = CurrentPlanNameGrp), BLANK()
)

 

Thank you so much for your help MFelix 

MFelix's avatar
MFelix
Super User
1 year ago

Glad to know you were able to made it work.

 

Since I did not know how your model was setup I just gave an approximate formula. But happy that I guided you to the correct path.