How to create a measure to count another measure??

[zraptor]

Hello all!

I am having a problem, I have a table that shows 5 columns.  The first 4 columns are actual dataset columns and the 5th is a measure.  The data table lists location IDs with and average start time and average end time by end of week.  The last column is the average variance between start and end however this is a measure and not a table column.  The location are to not have a variance of more than 15 minutes.  I need to create a measure that counts how many location made the variance goal of 15 or less for each week.  For the life of me I can't figure out how to pass the count of locations that made goal onto another calculation.  The person with the answer is a hero!!  Below is an example of the data table.  I want to be able to put the percentage out to the left of each section for the week.

Date	City	AVG Start	AVG End	AVG Variance		% Compliant
3/14/2023	ATL	18:30	18:45	15
	BOS	18:15	18:45	30
	JFK	19:05	20:00	55
	LAX	21:30	21:33	63		62%
	SFO	13:30	13:45	15
	SEA	14:30	14:45	15
	MSP	12:30	12:45	15
	DTW	17:00	17:15	15
3/15/2023	ATL	8:00	8:10	10
	BOS	9:15	9:20	5
	JFK	8:45	8:50	5
	LAX	12:00	12:15	15		75%
	SFO	23:10	23:30	20
	SEA	22:00	22:10	10
	MSP	8:15	9:00	45
	DTW	22:15	22:20	5
3/16/2023	ATL	15:00	15:05	5
	BOS	12:00	12:30	30
	JFK	14:30	14:45	15
	LAX	14:15	14:20	5		87%
	SFO	19:00	19:10	10
	SEA	19:45	19:50	5
	MSP	10:00	10:05	5
	DTW	9:30	9:45	15

[zraptor]

This is working great for the table itself but shows as 'BLANK' when dropped in a card.

[Ahmedx]

show what kind of card and what result you expect

[Ahmedx]

if you need more than or equal to 15 then change here

[Ahmedx]

here are two measures that solve your problem. they both give the same result

if you need more than or equal to 15 then change here
FILTER ( 'Table', [AVG Variance] >= 15 )

[zraptor]

@AH , my apologies, you are correct!  My math was wrong.  I'm excited to see the correct math in your column!  The hard part is can you display that percentage in a card sepretely of the table?

I just did this and I get a count of the locations out of range but ONLY if dropped into the table, I get nothing (blank) when used in a card....    

countrows(FILTER('Location_Times',[VAR Time]>15))

[Ahmedx]

I understand why YOU have 62% because you incorrectly calculated the difference in this place:
Los Angeles 21:30 21:33 63
you should have 3 minutes and not 63, that's where you have 62%

[Ahmedx]

Are you sure of your calculation? I got such a percentage
explain how you received 62% on the date 3/14/2023?