Power BI DAX

[muhammadmuhib20]

Hello folks,

Need some guidance on the below scenario.

I have a below table in my Power BI data model:

I have attendance against my OMNI source and Revenue against my IG source and attendance is against the facilities for each day 
where as the revenue is outlet wise there are many outlets in a given facility.




what i wanted to get the output as the sencod table where I can fix the attendace by Facility and As of Date.

Facility	As of dat	Source Name	Actual Attendance	Outlet Name
ABC	6/18/2024	OMNI	5526
ABC	6/19/2024	OMNI	2259
ABC	6/20/2024	OMNI	2456
ABC	6/21/2024	OMNI	3450
ABC	6/18/2024	IG		Bennos Race
ABC	6/19/2024	IG		Caricature
ABC	6/20/2024	IG		Dri Exp

Facility	As of date	Source Name	Actual Attendance	Outlet Name	Total Attendance	Revenue	Per Cap
ABC	6/18/2024	OMNI	5526		5526	0	0
ABC	6/19/2024	OMNI	2259		2259	0	0
ABC	6/20/2024	OMNI	2456		2456	0	0
ABC	6/21/2024	OMNI	3450		3450	0	0
ABC	6/18/2024	IG		Bennos Race	5526	50000	9.048136
ABC	6/19/2024	IG		Caricature	2259	25000	11.06684
ABC	6/20/2024	IG		Dri Exp	2456	40000	16.28664

I need to get the percap by each outlet but couldn't do it as attenance is not there that i need to fix it.
I can easily do it in Talbeau by using Fixed LOD by Faciiltiy Name and As of Date but struggling here in Power BI.

can anyone please suggest how can i acheive this Power BI using DAX.
I dont want to use SUMMARIZE and then do a lookup as my data volume is huge.

Thanks in advance

[Anonymous]

Hi @muhammadmuhib20 

I don't quite understand your needs. “what i wanted to get the output as the second table where I can fix the attendace by Facility and As of Date.” What is the exact logic of the "fix"? It would be nice if you could illustrate this in conjunction with the desired outcome of the example data. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu