Create 2 tables one dependent on ther other

[antoniofallucca]

I have a problem I'm in need of 2 date filters the 2nd filter depends on the selection of the first.  The filter utilizes the date dimension in a ssas tabulat cube using a direct connect.

The first filter would have all of the dates from the date dimension table as shown below.

First Filter:

Dates

Jan 2015

Feb 2015

Mar 2015

Apr 2015

May 2015

Jun 2015

Jul 2015 etc.

When I select say Jan 2016, Feb 2016, Mar 2016 the second filter should not show dates less than or equal to the largest date I have selected.

Filter 2

Dates:

Apr 2016

May 2016

Jun 2016

Jul 2016

Aug 2016 etc.

I will also need to use both return values in a measure.  So the first will be prior period calculations and the second will be current perion calculations.  The user will need to select both in the correct order so the second filter should be blank.

Hopefully someone can help me on this.

Thank you,

Antonio

[v-jiascu-msft]

@antoniofallucca,

Hi Antonio,

The filters here could be the Slicer. But the slicer can't be dynamic in your way. Firstly, we can make two slicers work independently by "Edit interactions". (I assume the two slicer from one column). But we can't make the slicer change dynamically. 

If you explain why you need the two slicers this way, maybe we can find a workaround.

Best Regards!

Dale

[antoniofallucca]

We have a report in SSRS that we can do this with.  It is strickly a end user requirement, they have in it in SSRS and will want it in the solution we create in Power BI.  I was thinking a dynamic table using DAX, but then again I don't know if that is possible.  I was hoping someone had seen this before as it is an important function / requirement for our end users.

The calculations are seperate for each slicer.  So for data 1 you have the previous calculations in a table then for data 2 you have the current and we don't want confusion for our users.

I hope this helps and perhaps you see my issue.  The report looks a little like this.

data 1 filter (previous)                                                                                      data 2 filter (current)

Report 1                                                                                                           Report 2

lables and values                                                                                              lables and values

Let me know your thoughts on this

This is how we do it in SSRS:

MEASURE '_Billing'[prior_work_rvu] =

        CALCULATE (

            '_Billing'[unit_measure],

            PATHCONTAINS ( @p_dos_month_prior, 'Date Of Service'[Serv Yr Month Num] )

        )

  MEASURE '_Billing'[curr_work_rvu] =

        CALCULATE (

            '_Billing'[unit_measure],

            PATHCONTAINS ( @p_dos_month_curr, 'Date Of Service'[Serv Yr Month Num] )

        )

[v-jiascu-msft]

@antoniofallucca,

Hi Antonio,

Measures can filter dates indeed. But they can't be used in the visual Slicer by now.  Maybe there is a workaround. The first Slicer shows dates in type "Before" while the second Slicer shows Year-Month in type "List". You can have a try.

Best Regards!

Dale