Forum Discussion

rogelep's avatar
rogelep
Regular Visitor
3 months ago
Solved

Using SelectedValue in measure for computing volume

Hello,   Need help in setting up a measure that counts the number of rows that have a date that is selected in a slicer. I used these measures: SelectedDate = selectedvalue('Complaints Raw Data'[...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    3 months ago

    The fix is to move the SELECTEDVALUE inside the measure using a VAR:

    Volume =
VAR _SelectedDate =
    SELECTEDVALUE ( 'Complaints Raw Data'[Date Received] )
RETURN
    CALCULATE (
        COUNT ( 'Complaints Raw Data'[short_id] ),
        'Complaints Raw Data'[Date Received] = _SelectedDate
    )
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 months ago

    Hi,

    Create a Calendar table and have a *:1 relationship from the Date received column to the Calendar table.  To your slicer, drag the Date from the Calendar table.  Write this measure

    Volume = count('Complaints Raw Data'[short_id])

    Hope this helps.

     

v-echaithra's avatar
v-echaithra
Community Support
3 months ago

Hi rogelep ,

Thank you Ashish_Mathur , cengizhanarslan , danextian , grazitti_sapna  for your inputs.
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Thank you.