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