topic Power BI DAX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-DAX/m-p/4001577#M155959 <P>Hello folks,<BR /><BR />Need some guidance on the below scenario.<BR /><BR />I have a below table in my Power BI data model:<BR /><BR />I have attendance against my OMNI source and Revenue against my IG source and attendance is against the facilities for each day&nbsp;<BR />where as the revenue is outlet wise there are many outlets in a given facility.<BR /><BR /><BR /><BR /><BR />what i wanted to get the output as the sencod table where I can fix the attendace by Facility and As of Date.</P><TABLE><TBODY><TR><TD>&nbsp;Facility</TD><TD>As of dat</TD><TD>Source Name</TD><TD>Actual Attendance</TD><TD>Outlet Name</TD></TR><TR><TD>ABC</TD><TD>6/18/2024</TD><TD>OMNI</TD><TD>5526</TD><TD>&nbsp;</TD></TR><TR><TD>ABC</TD><TD>6/19/2024</TD><TD>OMNI</TD><TD>2259</TD><TD>&nbsp;</TD></TR><TR><TD>ABC</TD><TD>6/20/2024</TD><TD>OMNI</TD><TD>2456</TD><TD>&nbsp;</TD></TR><TR><TD>ABC</TD><TD>6/21/2024</TD><TD>OMNI</TD><TD>3450</TD><TD>&nbsp;</TD></TR><TR><TD>ABC</TD><TD>6/18/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Bennos Race</TD></TR><TR><TD>ABC</TD><TD>6/19/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Caricature</TD></TR><TR><TD>ABC</TD><TD>6/20/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Dri Exp</TD></TR></TBODY></TABLE><P><BR /><BR /><BR /></P><TABLE><TBODY><TR><TD>Facility</TD><TD>As of date</TD><TD>Source Name</TD><TD>Actual Attendance</TD><TD>Outlet Name</TD><TD>Total Attendance</TD><TD>Revenue&nbsp;</TD><TD>Per Cap</TD></TR><TR><TD>ABC</TD><TD>6/18/2024</TD><TD>OMNI</TD><TD>5526</TD><TD>&nbsp;</TD><TD>5526</TD><TD>0</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>6/19/2024</TD><TD>OMNI</TD><TD>2259</TD><TD>&nbsp;</TD><TD>2259</TD><TD>0</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>6/20/2024</TD><TD>OMNI</TD><TD>2456</TD><TD>&nbsp;</TD><TD>2456</TD><TD>0</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>6/21/2024</TD><TD>OMNI</TD><TD>3450</TD><TD>&nbsp;</TD><TD>3450</TD><TD>0</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>6/18/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Bennos Race</TD><TD>5526</TD><TD>50000</TD><TD>9.048136</TD></TR><TR><TD>ABC</TD><TD>6/19/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Caricature</TD><TD>2259</TD><TD>25000</TD><TD>11.06684</TD></TR><TR><TD>ABC</TD><TD>6/20/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Dri Exp</TD><TD>2456</TD><TD>40000</TD><TD>16.28664</TD></TR></TBODY></TABLE><P><BR /><BR />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.<BR />I can easily do it in Talbeau by using Fixed LOD by Faciiltiy Name and As of Date but struggling here in Power BI.<BR /><BR />can anyone please suggest how can i acheive this Power BI using DAX.<BR />I dont want to use SUMMARIZE and then do a lookup as my data volume is huge.<BR /><BR />Thanks in advance<BR /><BR /><BR /><BR /><BR /></P> Thu, 20 Jun 2024 09:16:43 GMT Anonymous 2024-06-20T09:16:43Z Power BI DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-DAX/m-p/4001577#M155959 <P>Hello folks,<BR /><BR />Need some guidance on the below scenario.<BR /><BR />I have a below table in my Power BI data model:<BR /><BR />I have attendance against my OMNI source and Revenue against my IG source and attendance is against the facilities for each day&nbsp;<BR />where as the revenue is outlet wise there are many outlets in a given facility.<BR /><BR /><BR /><BR /><BR />what i wanted to get the output as the sencod table where I can fix the attendace by Facility and As of Date.</P><TABLE><TBODY><TR><TD>&nbsp;Facility</TD><TD>As of dat</TD><TD>Source Name</TD><TD>Actual Attendance</TD><TD>Outlet Name</TD></TR><TR><TD>ABC</TD><TD>6/18/2024</TD><TD>OMNI</TD><TD>5526</TD><TD>&nbsp;</TD></TR><TR><TD>ABC</TD><TD>6/19/2024</TD><TD>OMNI</TD><TD>2259</TD><TD>&nbsp;</TD></TR><TR><TD>ABC</TD><TD>6/20/2024</TD><TD>OMNI</TD><TD>2456</TD><TD>&nbsp;</TD></TR><TR><TD>ABC</TD><TD>6/21/2024</TD><TD>OMNI</TD><TD>3450</TD><TD>&nbsp;</TD></TR><TR><TD>ABC</TD><TD>6/18/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Bennos Race</TD></TR><TR><TD>ABC</TD><TD>6/19/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Caricature</TD></TR><TR><TD>ABC</TD><TD>6/20/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Dri Exp</TD></TR></TBODY></TABLE><P><BR /><BR /><BR /></P><TABLE><TBODY><TR><TD>Facility</TD><TD>As of date</TD><TD>Source Name</TD><TD>Actual Attendance</TD><TD>Outlet Name</TD><TD>Total Attendance</TD><TD>Revenue&nbsp;</TD><TD>Per Cap</TD></TR><TR><TD>ABC</TD><TD>6/18/2024</TD><TD>OMNI</TD><TD>5526</TD><TD>&nbsp;</TD><TD>5526</TD><TD>0</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>6/19/2024</TD><TD>OMNI</TD><TD>2259</TD><TD>&nbsp;</TD><TD>2259</TD><TD>0</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>6/20/2024</TD><TD>OMNI</TD><TD>2456</TD><TD>&nbsp;</TD><TD>2456</TD><TD>0</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>6/21/2024</TD><TD>OMNI</TD><TD>3450</TD><TD>&nbsp;</TD><TD>3450</TD><TD>0</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>6/18/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Bennos Race</TD><TD>5526</TD><TD>50000</TD><TD>9.048136</TD></TR><TR><TD>ABC</TD><TD>6/19/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Caricature</TD><TD>2259</TD><TD>25000</TD><TD>11.06684</TD></TR><TR><TD>ABC</TD><TD>6/20/2024</TD><TD>IG</TD><TD>&nbsp;</TD><TD>Dri Exp</TD><TD>2456</TD><TD>40000</TD><TD>16.28664</TD></TR></TBODY></TABLE><P><BR /><BR />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.<BR />I can easily do it in Talbeau by using Fixed LOD by Faciiltiy Name and As of Date but struggling here in Power BI.<BR /><BR />can anyone please suggest how can i acheive this Power BI using DAX.<BR />I dont want to use SUMMARIZE and then do a lookup as my data volume is huge.<BR /><BR />Thanks in advance<BR /><BR /><BR /><BR /><BR /></P> Thu, 20 Jun 2024 09:16:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-DAX/m-p/4001577#M155959 Anonymous 2024-06-20T09:16:43Z Re: Power BI DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-DAX/m-p/4003146#M156155 <P><FONT>Hi&nbsp;Anonymous</LI-USER></FONT>&nbsp;</P> <P>&nbsp;</P> <P>I don't quite understand your needs. “<SPAN>what i wanted to get the output as the second table where I can fix the attendace by Facility and As of Date.</SPAN>”&nbsp;What is the exact logic of the "fix"?&nbsp;It would be nice if you could illustrate this in conjunction with the desired outcome of the example data.&nbsp;<A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">How to provide sample data in the Power BI Forum - Microsoft Fabric Community</A> 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.</P> <P>&nbsp;</P> <P>Best Regards,<BR />Yulia Xu</P> Fri, 21 Jun 2024 03:07:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-DAX/m-p/4003146#M156155 Anonymous 2024-06-21T03:07:55Z