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.
Hi all,
Hopefully this is quite straightforward, but I can't seem to be able to find the solution to it.
I have a parameter that changes based on different time bucket columns (1hr column, 15min column etc.)
What I would like to do is create a measure that will calculate the number of instances where the sum of the parameter on a 15min interval is above 25.
My data look like this on a pivot
10:00 - 10:15 | 10:15 -10:30 | 10:30 - 10:45 | 10:45 - 11:00 | ... | ... | ... | |
Employer 1 | 15 | 19 | 25 | 15 | |||
Employer 2 | 22 | 55 | 40 | 22 | |||
Employer 3 | 30 | 40 | 26 | 30 | |||
Employer 4 | 45 | 20 | 40 | 45 | |||
Measure Required COUNT (Above 25) | 2 | 3 | 4 | 2 |
What I would like to have as a final product is the below.
10:00 - 10:15 | 10:15 -10:30 | 10:30 - 10:45 | 10:45 - 11:00 | ... | ... | ... | |
Measure Required COUNT (Above 25) | 2 | 3 | 4 | 2 |
Any idea?
Thanks in advance
Solved! Go to Solution.
@athgeor , Try a measure like
countx(filter(values(Table[Employee]), [Count measure] >1 ), [Employee])
For below visual , you can use show on row in Matrix
@athgeor , Try a measure like
countx(filter(values(Table[Employee]), [Count measure] >1 ), [Employee])
For below visual , you can use show on row in Matrix
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |