Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
76 | |
72 | |
65 |
User | Count |
---|---|
140 | |
109 | |
103 | |
82 | |
73 |