Stop repeating Meassure values in GRID

[MSFTPBI]

Hello,

My Table name is STOCKS, and I created a meassure called "HIGH_Price". As you can see, when I bring the meaasure to Table visual, values repeat , but I only want to show high value once like 108 for MSFT for 10/1/25, 289 for AMZN for 10/1/25.

Thanks in advance.

[MSFTPBI · Accepted solution]

No worries, I git it.

Dist_High_Price =

VAR MaxPrice =

    CALCULATE(

        MAX(TBL_Offfset[Close_Price]),

        ALLEXCEPT(TBL_Offfset, TBL_Offfset[Symbol])

    )

VAR v_MAX_Price = MAX([Close_Price])

RETURN

IF(v_MAX_Price = MaxPrice, MaxPrice, BLANK())