Forum Discussion
How can I only filter one region
Community SupportHi herwet
Thanks for reaching out to us.
In your code, the filter conditions have been written in the fixed area. So if you want only to filter the ACON region, you can use slicer.
(1) create the slicer
(2) create the measure below
test = IF(ISFILTERED(Slicer[slicer]),IF(MIN('Fact Table'[Region u/ACON]) in ALLSELECTED(Slicer[slicer]),"true","false"),"")result
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.
Hi v-xiaotang, thank you for responding 😊
I would like to visualize the data in a clustered column chart to compare the different regions and their performance 2021 vs 2022.
This means I need to make a measure for cost reimbursement for 2021 and one for 2022. The issue is that Cost reimbursement for 2021 has some other profit centers than 2022, so I would need to specify these profit centers in the measure.
Do you know how I can write my DAX for this?
- v-xiaotang
Hi 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.