Forum Discussion

learningOh's avatar
learningOh
Frequent Visitor
2 years ago

Dynamic Segmentation performance slow in a matrix visual

Hi all,   i have a DAX measure that tags a status to the my customers.       Acct WinLoss = Var cy = [Rev Current Year W/0 Scale] var py = [Rev Prior Year W/0 Scale] var ccy = [Count of ...
Fowmy's avatar
Fowmy
Super User
2 years ago

learningOh 

Please try this meaure. Take a look at your model and the other measures. This article will be helful: 
Optimization guide for Power BI - Power BI | Microsoft Learn

Count of Non-Zero Revenue Months =
VAR fy =
    MAX ( 'Calendar'[Fiscal_Year] )
RETURN
    COUNTROWS (
        FILTER (
            ADDCOLUMNS (
                SUMMARIZE (
                    FILTER ( 'InMarket Sales', [fiscal year] = fy ),
                    'Calendar'[calendar date day 1]
                ),
                "NonZeroRevenue", SUM ( 'InMarket Sales'[USD @ Latest FY Bud] )
            ),
            [NonZeroRevenue] > 0
        )
    )

 

learningOh's avatar
learningOh
Frequent Visitor
2 years ago

Thank you for sharing this approach. it helped to cut down the time needed to load. is there any other method to further improve? the loading time is still slow

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    learningOh 

    Optimizing the performance of a Power BI file requires a closer examination of the data model and measures. Without specific details, it's challenging to provide precise solutions. Various factors impact performance, such as data model complexity, connectivity mode (Import/DQ/AS), inefficient DAX measures, or suboptimal relationships. To offer tailored advice, I'd need more insights into your setup. Feel free to share specific aspects, and I can guide you more effectively.