Affect of 1 filter on another (both are dimension tables)

[klehar]

Hi,

I have 2 tables both are dimension tables that cannot be/should not be joined directly

Fiscal Year Quarter is my slicer on dashboard

Conditin 1 : If Fiscal Year Quarter = Fy23 : then show only FY23 workloads from Workloads table

Conditin 2 : If Fiscal Year Quarter = Fy24 : then show both FY23 and FY24 workloads from Workloads table

Table 1

DIM Date

Fiscal Year Quarter

FY23

FY24

Table 2

DIM Workloads

Workload	Flag
AI	FY23Q2
Compute	FY24Q1
Storage	FY24Q2

[Anonymous · Accepted solution]

Hi @klehar ,

Please try this way:
You can try this DAX to create a new measure:

Measure = 
IF(
    SELECTEDVALUE('DIM Date'[Fiscal Year]) = "FY23",
    IF(LEFT(SELECTEDVALUE('DIM Workloads'[Flag]), 4) = "FY23", 1, 0),
    1
)

I extracted the first 4 characters in this column for comparison:

Then put this measure into the "Filters on this visual":

The results are shown below:

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

[PijushRoy]

Hi @Anonymous 

Using Left in SELECTEDVALUE is a good idea. Thanks

[PijushRoy]

@klehar 

Can you please share one sample pbix file

[PijushRoy]

Hi @klehar 

Can you please try to implement below idea
1. Create a new calculated column in Table2 which shows Fiscal Year FY23,FY24
2. Use Variable in Selectedvalue from Table 1, use SWITCH statement if FY23 selected then Table2 only show FY23 data, when  FY24 is selected that time it should REMOVEFILTER

[klehar]

I'm confused, can you demonstrate please