Forum Discussion
Solved
Stop repeating Meassure values in GRID
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 ...
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])RETURNIF(v_MAX_Price = MaxPrice, MaxPrice, BLANK())
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())