Forum Discussion
KevinSV
Helper II
Helper IIMultiplying values with a certain filter value
Hello, I try to multiply 2 values between them but i have no results. First of all, i have a table which had a column called Credits (in decimal number format) ; I create a table which called coef...
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
MNedix
Solution Sage
Solution SageHeya,
The issue may also come from formatting. If you put in a card only the below, what do you get?
CreditsCoeff = SELECTEDVALUE(Coefficient[Pourcentage];1)