Forum Discussion

nimp_kp's avatar
nimp_kp
Frequent Visitor
6 years ago

Optimizing measure

Hi   I have made the following measure, used in a matrix, that gives me the correct data. But because of the massive amount of data in the dataset, it takes several minutes to display the data and...
DAX
if statement
Measures
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago

nimp_kp One thing you can try is to replace DISTINCTCOUNT with SUMX.

 

Measure =
IF (
    HASONEVALUE ( Table_1[Column_1] ),
    IF (
        [Measure_1] = 0.5
            && ( [Measure_2] - [Measure_3] >= 0 )
            && [Measure_4] = 1,
        IF (
            CALCULATE (
                SUMX (
                    VALUES ( Table_2[Column_1] ),
                    1
                ),
                Table_2[Column_2] = "Y"
            ) >= 1,
            [Measure_5]
        )
    )
)