DirectLake CU Consumption

[tolgakurt]

Hello.

I am using FT1 trial capacity in Fabric. I created a spark notebook -> lakehouse -> powerBI (DirectLake connection) report on a Workspace.

I created 2 large fact tables (Each table has about 60M rows and 10-11 columns) and 7-8 dimension tables in Lakehouse and I connect to these tables with direct lake and report.

I also track CU usage via Metrics App.

On 2025-05-30, my teammate and I connected to the report for the trial and applied filters to some pages. (For CU usage and report performance testing).

We applied filters to each page and closed the report. CU usage was much higher than we expected. I am sharing it below.

Is this usage normal? Only Query used about 200k CU in test usage.

[v-echaithra]

Hi @tolgakurt ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

[v-echaithra]

Hi @tolgakurt ,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

[v-echaithra]

Hi @tolgakurt ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra.

[burakkaragoz]

Hi @tolgakurt ,

To make TargetDayRevenueSCG dynamic based on the SalesChannelGroup, you can use a SWITCH statement that evaluates the current context. Here's a clean way to do it:

TargetDayRevenueSCG = 
VAR DaysInMonth = MAX(DIM_DATE[NumberOfDaysInTheMonth])
RETURN
    SWITCH(
        SELECTEDVALUE(SalesChannelGroup),
        "Leisure", SUM(TTVBudget[LeisureRevenue]) * DaysInMonth,
        "MICE/Intelligence", SUM(TTVBudget[MICEResidential]) * DaysInMonth,
        "Travel/Intelligence", SUM(TTVBudget[TransientRevenue]) * DaysInMonth,
        BLANK()
    )

Make sure:

• Your SalesChannelGroup is in the visual context (like in a table or slicer)
• The relationships between your tables are solid, especially on MonthKey
• Your DIM_DATE table is marked as a proper date table

If you're using SUMX for row-level logic, let me know and I can help adjust the measure accordingly.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.