Percentage of Monthly Numbers based on over

[DylanBanINT]

I have a table (example below) which has a set of values, I've set up another column to populate with a 1 whenever that value is higher than a certain number.

I am trying to calculate the percentage of how many times the value is over a certain amount so I can put this into a monthly graph

Going by the below graph the values should be roughly 50% for January, 33% Feb and 75% for March however unsure on how I would get these into a table. Any help appreciated.

Year-Month	Value	Over 1	Percentage Of
January 2022	0.9	null
January 2022	1.2	1
January 2022	1.3	1
January 2022	0.85	null
February 2022	0.2	null
February 2022	1.2	1
February 2022	1.3	1
March 2022	1.5	1
March 2022	1.6	1
March 2022	1.8	1
March 2022	0.9	null

[VahidDM · Accepted solution]

Hi @DylanBanINT 

You can use a measure like below:

Over a Number =
VAR _Over1 =
    CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Value] > 1 )
VAR _Overall =
    COUNTROWS ( 'Table' )
RETURN
    DIVIDE ( _Over1, _Overall )

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube