Forum Discussion

amarsale85's avatar
amarsale85
Helper II
5 years ago

PATHCONTAINS and Multiple selected value

Hi Experts,   i have created below measure to calculate aggregated profit amount for locations at parent level (like Continent, Country, Province) which would be summation of children cities. Our D...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

Here are some options:

 

- use MIN/MAX instead of SELECTEDVALUE

- use TOPN(1,FILTERS())

- make your slicer single select.

amarsale85's avatar
amarsale85
Helper II
5 years ago

Thank you for your reply.

Is there a way to take all multiple values and apply it to the measure in PathContains() function?

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    yes, convert your path into a table variable and then use INTERSECT()

      • amarsale85's avatar
        amarsale85
        Helper II
        5 years ago

        Thank you lbendlin for your suggestion but it isn't working. Below is my code:

        Sum Amount:=
VAR SelectedLocations = 
SELECTCOLUMNS(
VALUES(DimLocation),
"LocationID", DimLocation[LocationID]+0 
)
VAR mytable =
SELECTCOLUMNS (
GENERATE (
ALL(DimLocation),
ADDCOLUMNS (
GENERATESERIES ( 1, PATHLENGTH ( [Calculated Path] ) ),
"PivotPath", PATHITEM ( [Calculated Path], [Value], 1 )
)
),
"LocationID", DimLocation[LocationID]+0,
"PivotPathKey", [PivotPath]
)
RETURN
CALCULATE ( 
SUM(FactAmount[Amount]), 
INTERSECT(mytable,SelectedLocations)
)

        This code gives me error.

        I used INTERSECT here, but it gives error since these 2 tables have different no. of columns. If i used NATURALINNERJOIN instead of INTERSECT, that gives an error as well.

         

        Can you suggest what else can be used in place of INTERSECT() ?

         

        Regards,

        Amar