Forum Discussion
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...
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
Hi Pp110784 ,
Believe the problem is on your syntax in my case I have done the following measure:
URL LINE VALUE =
VAR URLValue = "https://www.google.com/search?ie=UTF-8&q={"&SELECTEDVALUE('ABTTableData'[PLAN_NAME_GRP])&"}"
RETURN
IF(ISINSCOPE('ABTTableData'[PLAN_NAME_GRP])&&NOT ISINSCOPE('ABTTableData'[PLAN_SPONSOR_NAME]), URLValue)
Has you can see it work correctly:
Redo your measure to:
Plan 5500 link =
IF (
ISINSCOPE ( 'ABTTableData'[PLAN_NAME_GRP] )
&& NOT ISINSCOPE ( 'ABTTableData'[PLAN_SPONSOR_NAME] ),
MAX ( 'ABTTableData'[plan_5500_link] )
)Should work
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
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.