Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic visual level filter (calculated Measure Flag)

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,

 

Need Help
  • dax's avatar
    dax
    6 years ago

    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.

     

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Amit,

       

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

       

      Thanks,

  • dax's avatar
    dax
    Community Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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!