Forum Discussion

kylerwimbush's avatar
kylerwimbush
Icon for Helper I rankHelper I
3 years ago
Solved

If Date Slicer is ALL...

I am trying to create a measure that will display the value of another measure divided by 53 based on the value of the date slicer.  I want it to divide [EscCountAverage] by 53 if the date sli...
Need Help
  • Shaurya's avatar
    Shaurya
    3 years ago

    Hi kylerwimbush,

     

    This should do it:

     

    DateSlicerAll = IF(IF(SELECTEDVALUE('Date'[Date]),SUM('Date'[Week Number]),SUM('Date'[Week Number]))=10011, [Sum]/53, [Sum])

     

    Case when all dates are selected, you get 15 divided 53.

     

     

    For any other selection, you get 15.

     

     

    Works for you? Mark this post as a solution if it does!

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Assuming EscCountAverage is a measure you have written, try this measure

=if(selectedvalue('Calendar Table'[Week])="All",divide([EscCountAverage],53),[EscCountAverage])

Hope this helps.