Date table for table with many dates

[Anonymous]

Hello, 

My model already has a date table connected to about four tables.    Each "important" date in those tables is connected to the date table.   All good there. 

I have another table...let's call it our sales lifecycle table....that has about six different dates in it.   Lead create date, account create date, opportunity create date, etc.     In my particular case, I do not need this table to relate to any other tables in my model...I will just report on the details of this table only in regards to that table  (for example I will not be putting other visuals on this same report page that are connected to other tables).     

Question:   

1.   I would like to have, for example, a visual showing lead create date, and another visual showing opportunity create date  (both by month).     If I put the values related to these (such as number of leads, number of opportunties) on the report canvas, and add their respective dates to each visual, then of course the dates in the visuals are related to their respective dates.  

Is there a way to have a "page level" filter for just this particular table  (Sales Lifecyle table), that would control all of the dates as sort of a "global filter"?    Or other ideas or solutions?     Just not sure the best way to handle this.  

Thanks!

[v-lili6-msft]

hi  @Anonymous 

It seems that it could not achieve in power bi, maybe you could share some simple sample data and your expected output, that will be a great help.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin

[lbendlin]

I wonder if ISFILTERED() and FILTERS()  works on page level?

https://docs.microsoft.com/en-us/dax/isfiltered-function-dax

Another approach would be inactive relationships and USERELATIONSHIP() in your new measures.