Forum Discussion

Alex_'s avatar
Alex_
Frequent Visitor
5 years ago
Solved

Summarizing a column from another table while using a slicer

Hi! I have two tables with the following, in a one-to-many relationship:   Data ID Value AB $1 XY $2 CZ $3   Activities ID Name Status AB Bobby In Progress XY B...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi,  Alex_ 

     

    Accord to your description, I think you can create a measure to display in table visual.

    Like this:

    Measure = 
VAR a =
    VALUES ( Activities[Status] )
RETURN
    IF (
        "In Progress" IN a,
        "In Progress",
        IF ( "Waiting" IN a, "Waiting", IF ( "Complete" IN a, "Complete" ) )
    )

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi,  Alex_ 

 

Accord to your description, I think you can create a measure to display in table visual.

Like this:

Measure = 
VAR a =
    VALUES ( Activities[Status] )
RETURN
    IF (
        "In Progress" IN a,
        "In Progress",
        IF ( "Waiting" IN a, "Waiting", IF ( "Complete" IN a, "Complete" ) )
    )

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.