Multiplying values with a certain filter value

[KevinSV]

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 ! 

[Anonymous · Accepted solution]

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] ) * coeffselect

Best Regards

[KevinSV]

Thank you very much, It works ! 

[MNedix]

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)