If Date Slicer is ALL...

[kylerwimbush]

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 slicer is showing data for all weeks. But what I have now wont work because it cant convert the text string to a number. Maybe I am going about this the wrong way? Any help? 

[Ashish_Mathur]

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.

[Shaurya · Accepted solution]

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!

[kylerwimbush]

Had to switch up the values but once I did that it worked! Thanks, you are a big help. 

[aj1973]

Hi @kylerwimbush 

Can you share a sample of your PBIX please?