Forum Discussion
Multiplying 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 coeff and putting into this table a column Percentage and had only the 0,33,99 and 100 values (in percentage values).
I related this 2 tables with a column I created : Fictive = 1 (for the 2 tables)
I try to multiply the credits with the percentage which i made a slicer and where i can choose the percentage I need (for example, I filter with 33% with the slicer and want all ligns of credits multiply by 33%). The problem is that i have the same result as the origin credit (like 100% of the credit)
So with the formula take the 1 and didn't take my selectedvalue where i filter with a slicer :
Have you an idea ? I think thh relation is the problem but I have no idea ho to resolve this problem.
Thanks you for your helping !
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
3 Replies
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
Thank you very much, It works !
Heya,
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)
