topic Re: Power BI don't return good total in DAX Commands and Tips

Power BI don't return good total

Juju123 — Mon, 14 Apr 2025 11:56:53 GMT

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

Re: Power BI don't return good total

BeaBF — Mon, 14 Apr 2025 12:04:42 GMT

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

Re: Power BI don't return good total

v-prasare — Mon, 21 Apr 2025 11:50:55 GMT

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

Re: Power BI don't return good total

v-prasare — Thu, 24 Apr 2025 04:57:47 GMT

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

Re: Power BI don't return good total

v-prasare — Mon, 28 Apr 2025 09:30:44 GMT

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

Re: Power BI don't return good total

Juju123 — Mon, 05 May 2025 07:47:01 GMT

Hi,

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