Preventing a measure from summing up in KPI card

[Ikay]

Hi All,

I have a measure (and it is a percentage) or a couple. when I put it on a bar chart, it splits out by month correctly.

However, because of the nature of the requirement, I would like to use that same measure on a KPI card but this time, I want it show up as YTD number or average (preferrably YTD number)

My issue is that, in the KPI card, the measure sums up. Is there a way to get it to show as YTD number (I’ve tried this) or even average. It works however when I use the month slicer .The YTD measure I tried, when added to the card, comes up BLANK.

Here is the measure:

percent Availability 2nd pump = DIVIDE([Quarter hrs 4 stations], [Total Denominator] )
This is the Breakdown below:
Quarter hrs 4 stations = CALCULATE(
‘Key Measures’[34sum quarter hours],
FILTER(RELATEDTABLE(‘Appliance List’ ),
‘Appliance List’[Station] = “Ampthill” ||
‘Appliance List’[Station] = “Biggleswade” ||
‘Appliance List’[Station] = “Toddington” ||
‘Appliance List’[Station] = “Leighton Buzzard”
) )

**Total Denominator** = [Weekend hrs] + [Workday hrs] + [Possible hrs 3 stations]

	**Possible hrs 3 stations** = [34average day 96] * [34 Averge day in month] * 3
	
	**Weekend hrs** = 
	[Weekends Count] * 'Key Measures'[34average day 96]
	
	**Workday hrs** = 
	[Workday Count] * 54

Hope this makes a little sense - I know the DAX is not “cool”, I think its the nature of the data I’m working with. THANK YOU

[BrianJ]

@Ikay,

Cards can be challenging, because unlike tables, matrixes or charts, they don’t provide any inherent evaluation context. Thus, in situations like this you need to build the proper evaluation context into your measure in the form of a virtual table against which your measure can be evaluated.

This post explains the issue in depth with an example. The same approach should be directly applicable to your problem.

Using "All-in" Date Harvest Approach with Cards

I received the following interesting question regarding the Date Harvest Deep Dive video I did recently for the Enterprise DNA TV YouTube channel as part of the ongoing time intelligence series that @Melissa and I have been doing: [image] Billy is correct that the approach certainly is easier when you have an explicit evaluation context on date in the visual. However, for visuals that don’t contain this explicit evaluation context (e.g., cards, gauges, etc.), the approach absolutely still wor…

I hope this is helpful. If you need additional specific guidance, please post your PBIX and I’ll be happy to work through it with you.

– Brian

[Ikay]

Thanks Brian,
very much appreciate the quick reply. I’m currently trying out the solution.

Thanks again

[Ikay]

@BrianJ,

Thanks Brian, I tried the Inside range, but wasn’t quite able to get it to work. please if you can have a look. this is the measure in a bar chart vs in a card

KPI dashboard - Availability v2.pbix (1.1 MB)

Thank you so much. Also with this second visual, I’m not sure what the card does to the measure. it certainly doesn’t do an average.