count days from a slicer date

[Anonymous]

Hello Experts,

how do i get the dax for no of days from the date slicer?

I wanted to show the count between below date range and i dont want to use relative date. Once i get the count of days then again i need to calculate 3*1440(how iam this number is 24hrs in a day and 60minutes per hour so 24*60=1440)

I tried min, max, selectedvalue but no luck. Could you please help me someone

Below is the actual requirement from customer and GPH is a measure

Regards,

Venkat

[Greg_Deckler · Accepted solution]

@Anonymous You should be able to do:

Count Measure = ( MAX('Dates'[Date]) - MIN('Dates'[Date]) ) * 1.

[Anonymous]

@Greg_Deckler i tried already without multiplication 1 and now i tried as you said but no luck and even i tried with countrows that also not working

Regards,

Venkat

[Greg_Deckler]

@Anonymous So, what is the purpose of the 2 slicers?

[Anonymous]

@Greg_Deckler Just for illustration purpose only showed relative date slicer. Only required Date slicer. 

Can anyone help me on the dax? @MFelix @amitchandak @Ashish_Mathur any help here

[MFelix]

Hi @Anonymous ,

I have made a test and all the metrics refered here work properly, no issues on the calculation, believe that you may have some relationship, or context filter that is causing this calculation to not work.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[Anonymous]

@Greg_Deckler Thank you greg. its working both solutions after i reviewed joins.

@MFelix Thanks Felix for your valuable suggestions