Return 1 instance of maximum power per outlet

[chrisw888]

Hi

Would anyone be able to point me in the right direction of what DAX function i could use to get around the below issue?

I have a rows and rows of data for sites that I have charging outlets. My issue is I could have one site (each site has a unique identifier) that can deliver say 100kwh in the day as its maximum output, and each day could vary as to how many sessions I have and how much of this 100kwh I have been able to supply. I am therefore trying to calculate a utilisation %, depending on whether I have delivered 10kwh, 20kwh, 25kwh or whatever value I delivered that day of my total 100kwh.

The problem I have is I am struggling to write my dax that counts the energy I delivered, and divide it by the total of 100kwh, instead I only ever appear to be able to return for example, my energy, divided by 500kwh, if i had 5 sessions that day, or 600kwh if i had 6 sessions, and so on.

Its something probably simple to someone with DAX experience, but I am bit stuck with it.

Thanks

[Manoj_Nair · Accepted solution]

@chrisw888- Check this out, let me know if this works.

Utilization % = 
    VAR TotalEnergyDelivered = SUM('Table'[EnergyDelivered])
    VAR MaxOutput = 100
    RETURN DIVIDE(TotalEnergyDelivered, MaxOutput)

If you use this measure in a table with a row for each day, it will calculate the utilization percentage for each day. If you use this measure in a card visual, it will calculate the overall utilization percentage for all days.

I've hypothetically established this DAX measure, but without much clarity regarding your datasets. If this doesn't serve your needs, I recommend you share a sample dataset. This will give me a more comprehensive understanding of your data structure, enabling me to devise a more suitable solution. Cheers

[chrisw888]

Hi

I was able to adapt your DAX and have now got myself sorted, thank you so much for your help. Now just need to figure out how to use the same and visualise it as a monthly average for each charger power

[chrisw888]

Hi,

Thanks for coming back to me, and this looks close to what I need. Below is some sample data (sorry it wont let me attach a file), but as a guide, the 50 on the 17/3 sees a utilisation of 5.48%, being 20.336+37.351+8.026 divided by the 50 *24 hours.

This is my data			For Ref
											50	22
Date	Period	Year	Month	kwh delivered	Power	charger				Daily Power Available	Utilisation %
17/03/2023	2023/03	2023	Mar	20.336	50	1				1200	5.48%
17/03/2023	2023/03	2023	Mar	37.351	50	1				1200
17/03/2023	2023/03	2023	Mar	8.026	50	1				1200
16/03/2023	2023/03	2023	Mar	28.013	50	1				1200	4.72%	0.80%
16/03/2023	2023/03	2023	Mar	25.471	50	1				1200
16/03/2023	2023/03	2023	Mar	4.2	22	2				528
16/03/2023	2023/03	2023	Mar	3.161	50	1				1200
15/03/2023	2023/03	2023	Mar	44.261	50	1				1200	5.13%	2.56%
15/03/2023	2023/03	2023	Mar	4.5	22	2				528
15/03/2023	2023/03	2023	Mar	9	22	2				528
15/03/2023	2023/03	2023	Mar	17.329	50	1				1200
14/03/2023	2023/03	2023	Mar	6.877	50	1				1200	7.88%	6.36%
14/03/2023	2023/03	2023	Mar	26.476	50	1				1200
14/03/2023	2023/03	2023	Mar	18.6	22	2				528
14/03/2023	2023/03	2023	Mar	15	22	2				528
14/03/2023	2023/03	2023	Mar	4.61	50	1				1200
14/03/2023	2023/03	2023	Mar	25.13	50	1				1200
14/03/2023	2023/03	2023	Mar	21.848	50	1				1200
14/03/2023	2023/03	2023	Mar	9.626	50	1				1200

[some_bih]

Hi @chrisw888 for some reasonobal dax / other solution the model with column is needed with example of data.