Forum Discussion

Juju123's avatar
Juju123
Icon for Helper III rankHelper III
1 year ago
Solved

Power BI don't return good total

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

 

DAX
power bi
total
  • BeaBF's avatar
    BeaBF
    1 year ago

    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's avatar
    Juju123
    1 year ago

    Hi, 

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

5 Replies

  • BeaBF's avatar
    BeaBF
    Icon for Super User rankSuper User
    1 year ago

    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

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    1 year ago

    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

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    1 year ago

    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's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    1 year ago

    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

  • Juju123's avatar
    Juju123
    Icon for Helper III rankHelper III
    1 year ago

    Hi, 

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