Forum Discussion
Helper IIMultiplying values with a certain filter value
Hi KevinSV ,
It seems that [CreditsCoeff] is a calculated column, so it will not change according to the user interaction(slicer, filter, column selections etc.) in the report as the value of a calculated column is computed during data refresh and uses the current row as a context... Please review the following links about the difference of calculated column and measure...
Calculated Columns and Measures in DAX
Calculated Columns vs Measures
Please create a measure as below to replace the original calculated column.
Measure_CreditsCoeff = VAR coeffselect = SELECTEDVALUE ( Coefficient[Pourcentage], 1 ) RETURN MAX ( Coefficient[CREDITS] ) * coeffselectBest Regards
Hi KevinSV ,
It seems that [CreditsCoeff] is a calculated column, so it will not change according to the user interaction(slicer, filter, column selections etc.) in the report as the value of a calculated column is computed during data refresh and uses the current row as a context... Please review the following links about the difference of calculated column and measure...
Calculated Columns and Measures in DAX
Calculated Columns vs Measures
Please create a measure as below to replace the original calculated column.
Measure_CreditsCoeff =
VAR coeffselect =
SELECTEDVALUE ( Coefficient[Pourcentage], 1 )
RETURN
MAX ( Coefficient[CREDITS] ) * coeffselectBest Regards
KevinSVThank you very much, It works !