Forum Discussion

jdalmass's avatar
jdalmass
Regular Visitor
3 years ago
Solved

Visual filter on a table dependent on another table

Hello hello, I would like to create a visualization that allows me to filter my data according to the column of a table "X" and that acts on my visualizations coming from a table "Y", itself depen...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi jdalmass ,

     

    According to your code, I think they are calculated columns. As far as I know, calculated column couldn't be dynamic by slicer

    If you want to get dynamic result which is filtered by slicer, I suggest you to create measures.

    Done = 
IF(MAX('Y'[Date]) <= TODAY(),
CALCULATE(COUNT('X'[Done Date]),
FILTER('X','X'[Done Date]=MAX('Y'[Date]))))
    Received = 
IF(MAX('Y'[Date]) <= TODAY(),
CALCULATE(COUNT('X'[Received Date]),
FILTER('X','X'[Received Date]= MAX('Y'[Date]))))

    Result is as below.

    Best Regards,
    Rico Zhou

     

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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi jdalmass ,

 

According to your code, I think they are calculated columns. As far as I know, calculated column couldn't be dynamic by slicer

If you want to get dynamic result which is filtered by slicer, I suggest you to create measures.

Done = 
IF(MAX('Y'[Date]) <= TODAY(),
CALCULATE(COUNT('X'[Done Date]),
FILTER('X','X'[Done Date]=MAX('Y'[Date]))))
Received = 
IF(MAX('Y'[Date]) <= TODAY(),
CALCULATE(COUNT('X'[Received Date]),
FILTER('X','X'[Received Date]= MAX('Y'[Date]))))

Result is as below.

Best Regards,
Rico Zhou

 

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