Latest Enterprise DNA Initiatives

Preventing a measure from summing up in KPI card

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

@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.

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

2 Likes

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

Thanks again

@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.

image