Power BI don't return good total

[Juju123]

Hello,

I'm having a problem with the total sum of a column.

I have several filters in my Power BI: Supervisor, Company, Creation date, etc.

In the example I'm showing you, I've only filtered on SUPERVISOR = FME AND FEL.

I have a column called "SUPERVISOR" and I want to calculate the total standard cost.
I created a calculated column to get the standard cost: Column A * (Price/Lot size)
The total standard cost is incorrect because Power BI isn't adding the results.
Power BI calculates as 68 * (Price/Lot size), whereas I want it to add the data in the "Standard Cost" column.

Thanks for your help

[BeaBF · Accepted solution]

@Juju123 Hi! can you paste the data under that visual? with formulas for the calculated columns/measures.

Meanwhile you can try with a measures like:

Total Standard Cost =
SUMX(
'YourTable',
'YourTable'[Colonne A] * ('YourTable'[Price] / 'YourTable'[Lot size])
)

THX,

BBF

[Juju123 · Accepted solution]

Hi, 

Finally i do this formula in ETL. Thanks for your answers. 

[v-prasare]

Hi @Juju123,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @Juju123,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @Juju123,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

@BeaBF , Thanks for your promt respons

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[BeaBF · Accepted solution]

@Juju123 Hi! can you paste the data under that visual? with formulas for the calculated columns/measures.

Meanwhile you can try with a measures like:

Total Standard Cost =
SUMX(
'YourTable',
'YourTable'[Colonne A] * ('YourTable'[Price] / 'YourTable'[Lot size])
)

THX,

BBF