Change a Table based on a Visual Filter of Unrelated Table

[areias_br]

Hi,

I have two tables in my DB.

Table 1: AllActions => This table contains all the information from actions that are opened in the system.
Table 2: tb_Weekly => This table contains all the last days of each year's week and a collum called "Opened Actions" that shows me all the actions that have been opened in the system until that date.

To generate this collum "Opened Actions" I use the following formula:

Opened Actions =
COUNTROWS(
FILTER(
'AllActions',
'AllActions'[Created Date] < 'tb_Weekly'[Date] )

So, it counts all the rows (actions) that were opened before the date of the tb_Weekly. It's working fine. 

Problem:
It always shows me all the results from the table AllActions. However, I need to generate this table based on the dynamic filters the user can input into the table AllActions. For example, the status of the actions, the owner etc.

Below you can see the graph based on the tb_Weekly "Opened Actions". It need it to change accordingly to the filter the user select on "Status" which is a collum from AllActions.

[Anonymous]

Hi @areias_br 

Based on your description, you can create a measure instead of the calculated column.

e.g 

MEASURE =
COUNTROWS (
    FILTER ( 'AllActions', 'AllActions'[Created Date] < MAX ( 'tb_Weekly'[Date] ) )
)

Then put the measure to the Y-axis.

the measure can changed dynamically by your slicer.

And you can refer to the attachments.

Yolo Zhu

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

[areias_br]

Hi,

It didn't work. It shows me, and I don't know why, only the itens that were opened in that month, while it should show ALL the actions opened at all. 

[Anonymous]

Hi @areias_br 

Thanks for your quick reply, you cna try the following measure.

MEASURE =
COUNTROWS (
    FILTER (
        ALLSELECTED ( 'AllActions' ),
        'AllActions'[Created Date] < MAX ( 'tb_Weekly'[Date] )
    )
)

Best Regards!

Yolo Zhu

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