Forum Discussion

IzuruWi's avatar
IzuruWi
Frequent Visitor
3 years ago

Improve the data loading performance of table visual

Hi all. I have started preparing a Power BI report to visualize information using table visual with drill down information option in a secondary tab in the same report. I want to increase the speed ...
Need Help
AbbasG's avatar
AbbasG
Memorable Member
3 years ago

IzuruWi can you share sample data or pbix after removing the sensitive information?

IzuruWi's avatar
IzuruWi
Frequent Visitor
3 years ago

Hi AbbasG  I found this dax causes some sort of a performance issue for the visualization. Can you please guide me to improve this dax?

SWITCH (
            TRUE (),
            CONTAINS (
                DIM_ANALYTIC_STRUCT_ACCOUNT,
                DIM_ANALYTIC_STRUCT_ACCOUNT[STRUCTURE_NODE (groups)], "1 - CURRENT ASSETS"
            ), SUM ( FACT_CONSOL_BALANCE_OL[BALANCE] ),
            CONTAINS (
                DIM_ANALYTIC_STRUCT_ACCOUNT,
                DIM_ANALYTIC_STRUCT_ACCOUNT[STRUCTURE_NODE (groups)], "2 - NON - CURRENT ASSETS"
            ), SUM ( FACT_CONSOL_BALANCE_OL[BALANCE] ),
            SUM ( FACT_CONSOL_BALANCE_OL[BALANCE] ) * -1
        )