help on multiplier parameter

[jip31]

Hello

I need to create a mesure with a multiplier parameter in order to multipliate the fields Sales which is a decimal number

But it doesn't works because Power Bi says there is a "circular dependancy"

What is the problem please?

MultiplierSales = 'financials'[Sales] * [Valeur Multiplier]

 Rgds

[jip31]

Is anybody can help please??

[v-kelly-msft · Accepted solution]

Hi  @jip31 ,

Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@jip31 , there can be a few reason for that, refer:https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Can you share a sample pbix after removing sensitive data.

[jip31]

Hello

I dont know why but now it's a new error message

The "Sales" column is not found

https://www.cjoint.com/c/KDjmXzT3cNr 

What I have to do please for working??

[Anonymous]

The error stating sales column can not be found is usually related to your query and the change type. Usually if you delete that step then refresh the query that can fix it. 

[v-kelly-msft]

Hi @jip31 ,

Can you upload your .pbix file or provide some sample data for test?

Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!