Forum Discussion

JohnCavil's avatar
JohnCavil
Helper I
6 years ago

Compare Card Values

I want to compare the values of two different cards that measure the same field but with two different dates.   So one card is affected by Date Slider X, and the other by Date Slider Y, but both ar...
Need Help
  • JohnCavil's avatar
    JohnCavil
    Helper I
    6 years ago

    Hey thanks for the reply, i think i'm getting close to what i want. 

     

    Based on the example in your link i now have this code for the measure 

     

    Measure =
    VAR vdate =
    SELECTEDVALUE ( 'Complete Data'[date] )
    RETURN
    CALCULATE ( SELECTEDVALUE ( 'Benchmark Data'[impressions] ); 'Benchmark Data'[date] = vdate )
    - SELECTEDVALUE ( 'Benchmark Data'[impressions] )
     
    However the issue is that i cannot get a SELECTEDVALUE out from my slicer (as there isn't a single value selected, but a range).
     
    But i think it could work if i use two tables that are copies of eachother, i just need to be able to get the selected value from the date slicer, or somehow just get the selected values of my "impression" field (based on the date selected). Basically i just need to know how to use the example you linked, but with a date slicer instead of a simple selection.
     
    Hope i make sense. Thanks for your time 🙂