Forum Discussion

ADAM_DUNWORTH's avatar
ADAM_DUNWORTH
Frequent Visitor
3 years ago
Solved

How to Compare Two Selected Values in A Filter

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 

 

 

 

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
    ADAM_DUNWORTH
    Frequent Visitor
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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