How to Compare Two Selected Values in A Filter

[ADAM_DUNWORTH]

Hi All 

Hoping someone can help me with a particularly tough problem 

I want to compare the difference between mulptiple selected values in a filter 

So if the user selects Date 1 [1st Jan] and Second Date in the Filter Say [1st Mar] 

The difference would be [+10] 

Im open to ideas on how to do this 

The way i was thinking of solving this was to split the volume into two different tables via (First Selection, Second selection) and then making a measure but i cannot seem to create two tables via the filter 

Filter - Selected Value but this does not seem to work 

I cannot pivot the columns as in the real use case the dataset is very large and the number of record dates is huge. 

Will really appreciate if someone knows how they'd do such a thing 

[ADAM_DUNWORTH]

yes apologies for the delay in response its not the ideal but it is a workable solution. thanks 

[Anonymous]

Yes, Sadly most solutions to what seems like a simple request have difficult fixes due to PowerBI not supporting simple logicial features the best. 

[Anonymous]

Hi @ADAM_DUNWORTH,

Did these two filters used the same table field as source? AFAIK, current power bi does not support to get different value from the same source table field.

You need to create an unconnected table as source for filter2 to get different selections values, then you can use it to compare with the raw filter selections.

Regards,

Xiaoxin Sheng

[ADAM_DUNWORTH]

Yes its all one table. I also tried making two seperate tables where which had a single distinct column for the date column and then tried via that way but the attempt still failed 

[Anonymous · Accepted solution]

Compare values based on two slicer selections - us... - Microsoft Power BI Community
See here. This should work for you aswell.