How optimize measure in order to consume less resources in Power BI

[Analitika]

Hello,

I would like to ask how to reduce resources by optmizing measure in Power BI. Because I added new measures and visual loading slow.

Here is an example:

Filtered measure_t = 
var a = SUMX (
    FILTER (
        VALUES ( 'N08-Klientai'[N08_PAV] ),
        [20_2_1_DATA PRADELSIMAS] >= 31 && [20_2_1_DATA PRADELSIMAS]<=60
    ),
    CALCULATE ( [18_1_0_BENDRA SKOLA (nuo istorijos pradzios)] )
)
return a 

18_1_0_BENDRA SKOLA (nuo istorijos pradzios) is a measure also.

[Anonymous]

Hi @Analitika ,

Please try below dax formula:

Filtered measure_t =
VAR _measure = [18_1_0_BENDRA SKOLA (nuo istorijos pradzios)]
VAR _tmp =
    FILTER (
        VALUES ( 'N08-Klientai'[N08_PAV] ),
        [20_2_1_DATA PRADELSIMAS] >= 31
            && [20_2_1_DATA PRADELSIMAS] <= 60
    )
VAR a =
    SUMX ( tmp, _measure )
RETURN
    a

For more details, you can read related document: DAX Best Practices | MAQ Software Insights

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Analitika]

Does it make quicker calculation?