Filter two different columns with two different filters to compare baselines

[yanisyes]

Hi all, 

I want to create a report which compare two baseline for the same activity every month.

To do that I want to chose the baseline among few baseline to compare them. 

The objectif every month is to filter one column with the data from the last month baseline or a previous baseline and to filter another column with the data  of this month  baseline. 

I've tried to do like in this video  https://youtu.be/exN4nTewgbc from @amitchandak  for the two columns i want.

Date of the event 1 : I just put the column date of the event

Date of the event 2 : Date of the event 2 = MAXX(filter(Table2, 'Table2'[Baseline] in ALLSELECTED('Table'[Baseline])

But When I want to compare two baseline I have this as a result 

COuld you please help me?

Thank you

[Anonymous]

Hi @yanisyes, 

I have tried your solution and it does not seem to work to show the Activity in one row. I followed exactly your example, but used dates instead of the slicer B23, etc. 

Any suggestions or maybe you can share you pbix? 

[Anonymous · Accepted solution]

Hi @yanisyes ,

I suggest you to set the relationships between two slicer tables and your data table to unactive.

Measure: 

Data of event 1 = CALCULATE(MAX(Data[date of the event]),USERELATIONSHIP(Data[Baseline],Slicer1[Baseline]))

Data of event 2 = CALCULATE(MAX(Data[date of the event]),USERELATIONSHIP(Data[Baseline],Slicer2[Baseline]))

Result is as below.

Best Regards,
Rico Zhou

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

[lbendlin]

Most likely your slicers need to be fed by disconnected tables. 

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523