Forum Discussion
How can I only filter one region
Community SupportHi herwet
Thanks for your reply.
Usually we need to create a calendar table, put date column from calendar table into table visual, then create the measures like below,
total= calculate(sum(fact_table[value]),filter(all(fact_table),year(fact_table[date])=min(calendar[year])))
If Cost reimbursement for 2021 has some other profit centers than 2022, just make sure each record of those profit centers has date 2021-xx-xx, then we can find them by expression year(fact_table[date])=min(calendar[year]), finally get the correct total.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Another issue with this case is that profit centers that belonged to ACON in 2021 are now transferred to another region. For example, profit center "334220" belonged to ACON in 2021, in 2022 it belongs to Region Sørvest. Therefore, it is challenging to find the correct profit centers using the date table.