Issue with Including Zero Counts in Average Calculation Measure in PowerBI
Hello, I’m encountering an issue with a measure in PowerBI where I need to include zero counts in an average calculation. My current setup involves calculating the average number of sessions per CP ID, but I’m finding that the measure incorrectly excludes zero counts when a CP ID has no sessions on a particular date. (My data is regarding EV charging sessions) Here is my current set-up: 1. A measure to work out the average number of sessions per charger: SDR ID average per CP ID = AVERAGEX( KEEPFILTERS(VALUES('Pogo E Connect Data'[CP ID])), CALCULATE(COUNTA('Pogo E Connect Data'[SDR ID]))) 2. A measure to work out the average number of session dynamically using a customer Calendar table: Average Number of Sessions.1 = AVERAGEX( SUMMARIZE( 'Calendar', 'Calendar'[Year], 'Calendar'[Quarter], 'Calendar'[Month], 'Calendar'[Date], "Average Sessions", CALCULATE( AVERAGEX( VALUES('Calendar'[Date]), COALESCE([SDR ID average per CP ID], 0) ) ) ), [Average Sessions] ) My ultimate goal is to work out the Average number of sessions per charger per day. However some chargers do not have sessions everyday, which I tried to handle with COALESCE([SDR ID average per CP ID], 0), but frankly it just doesnt care and disregards the days without sessions. For example, on 18th June: Charger 1 = 3 sessions Charger 2 = 4 sessions Charger 3 = 0 sessions The measures are returning an average of 3.5 sessions, while the correct average should be 2.3. Does anyone have any ideas on how I could resolve this issue? I need to ensure that days with zero sessions are included in the average calculation. Any help or suggestions would be greatly appreciated!
Tooltips is only showing the first value , need to show respective value of a record in tooltip
Hi All, I wanted to show the respective record values in the tooltip, but I could see only the first value if I use that column in the tooltip, I have tried using the report page tooltip but I am seeing all the records with respect to that record, below is the screenshot attached 1. In the below image shows the first value of a record( Marketing) wherein it should show sales 2. while using the report page tooltip I could see all the records associated with that Any help will be greatly appreciated. Thanks & Regards, Suganthy
