Dynamic visual level filter (calculated Measure Flag)

[Anonymous]

Hi,

I'm using SSAS tabular Model as source for Power BI report.

Existing Set-up:

• I have Time Filter with values "Last Week", "Last 4 Weeks", "Last 3 Motnhs" 

Time Filter

Last Week

Last 4 Week

Last 3 Motnhs

• And have Flag columns for each Time value (above) in another table 

Route	LastWeekFlag	Last4WeekFlag	Last3MonthsFlag
A	1	1
B		1	1
C	1
D			1
E			1

Expected Output in Power BI:

• if Time Filter = "Last Week". Note - Measure should be visual level filter to apply on visual

Route	Measure
A	1
C	1

• if Time Filter = "Last 4 Weeks". Note - Measure should be visual level filter to apply on visual

Route	Measure
A	1
B	1

• if Time Filter = "Last 3 Months". Note - Measure should be visual level filter to apply on visual

Route	Measure
B	1
D	1
E	1

Please help me to solve this scenario.

Thanks,

[dax · Accepted solution]

Hi @Anonymous , 

Two workarounds: Convert table structure or try to use slicer to achieve this goal(single selection). You could refer to my sample for details.

Best Regards,
Zoe Zhi

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

[Anonymous]

Hi @cst,

Thanks for your time.

I gone through pbix provided, Workaround#1 (change table structure not feasible in my case, because it will change grain of data).

Workaround#2 (slicer with single selection) same solution I implemented last Friday, as small POC. So I concluded 2nd approach worked for my initial requirement.

Next I have to build next brick on top of it, which sounds more complicated requirement (I will post it here, if needed).

I'm happy to accept this as solution 🙂

Thanks a lot!

[amitchandak]

@Anonymous , refer if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

[Anonymous]

Hi Amit,

Thanks for reply. 
Gone through link sent, solution not fits into my problem statement.

Thanks,