measure with automatic total number days of month

[TechR21]

Hello,

Im using the following measure for a gauge to show the percentage of all runs of that month under 10 hours. This I do on a monthly base, so for januari i divide by 31.

Total % =

VAR less10 =

    CALCULATE ( COUNT ( 'Table'[Run] ), KEEPFILTERS ( 'Table'[Run] < 10 ) )

RETURN

    DIVIDE ( less10, 31 )

The gauge is on a page with different visuals, and Im using a filter to select the month that I want

How can I make this that it calculates the numbers of days in a month automatically, instead of putting a hard coded value in the measure?

[Greg_Deckler]

@TechR21 You could do something like this:

VAR __DaysInMonth = DAY(EOMONTH(TODAY(),0))

[TechR21]

I see its not the correct percentage when i look for the data of januari. Is this because the today part in the measure?

VAR __DaysInMonth = DAY(EOMONTH(TODAY(),0))

for januari i have 16 days of the 31 that are below 10 hours, so I get a percentage of 51.61, but the gauge shows

On the filter I selected all days of januari so this should be the range of calculation. If I select all the days of feb at the end of this month, I want the measure to show the percentage based on the days in feb

[TechR21]

VAR __DaysInMonth = DAY(EOMONTH(MONTH(-1),0)) this works:)

[v-jingzhang · Accepted solution]

Hi @TechR21 

Since you have a date filter, use the same date column in the variable:

VAR __DaysInMonth = DAY(EOMONTH(MAX('Date'[Date]),0))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.