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!
Matrix component drill down function, percentages are automatically summed
Hi Team,As shown in the figure above, the percentage is given by (No. of Applications -Exceeded 10 working days)/No. of Applications, but when we put the fold back, it becomes the sum of the 3 types, We want the result to still be calculated using the above expression, what should we do.Hope to hear from you soon. Thanks.
create a dashbord with multiple dimentions and mesaures. Do you know how?
Customer Completeness (to % completed) Validity (to % valide) Uniqueness (to % uniques) Consistency (to % consistent) First Name 29K empty 8,5K with invalid characters 38K at least 1 duplicate N/A Last name 34 empty 26K with invalid characters 38K at least 1 duplicate N/A
Count Data Points in a Quadrant of a scatter plot
Dear Ashish, Hello All Hope some one could help me please. I really need some help to count the # of points in each of the quardrants in the visual below. I have attached 2 visuals , the 2nd one is the data that is the tabular version of the data in the scatter plot. All are calculated measures except the store list. Please if you could respond. A store in Quadrant 1 ( red zone) is a store if its productivity index is lower than Target productivity Index ( 113% ) and lower than Last Year Productivity Index ( 111%). I was able to create the quadrant and visualize it in scatter plot but I now need to identify those stores separately and do calculations based on that.Problems with accumulative count
Hello, I've got some problem with this field (accumulative count) : Z_Cumul_Qtés = CALCULATE ( COUNT ([DOSSIER]), FILTER (ALL('DATA'[CI_MOIS]),DATA[CI_MOIS]<= MAX(DATA[CI_MOIS]) ) ) *** CI_MOIS is a numeric format for a month (not date format) DOSSIER is a reference (text) CI_ANNEE is a numeric format for a year (not date format) *** First chart = perfect (with filter CI_ANNEE=2022) Second chart = perfect (with filter CI_ANNEE=2021) Third chart = with filter CI_ANNEE 2022 & 2021, and legend CI_ANNEE = how is it possible ?
POWER BI LIVE DATA
Hi all, Please if you have a solution for this one! I have a real time database which I am using for creating some Dashboards on Power BI ( not tables from an excel file). These datas are refreshed daily ( maybe twice per day). My question is : There is any Dax formula I can use to calculate cycle time without having a table? I am using already a formula like : DATEDIFF(MAXX(RELATEDTABLE(PROCESS),PROCESS(INITIATION DATE),MAXX(RELATEDTABLE(PROCESSHISTORY),PROCESSHISTORY(COMPLETEDDATE),DAY) but it's not so accurate. I want to calculate the cycle time from starting date until the completed date and to have only those dates who have 30 days until the request is processed. Hope this is clear enough and thanks !
