Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Support for a Calculation

Hi,   Kindly support me to calculate this column     Revenue P1, Total P1 Revenue , Total Labour Cost P1 , Total Labour Cost P1 % --> Separate measures   I want to calculate the "Cost P1...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Anonymous 

    According to your describe, there could be several reasons why your measure is returning the same value in the table visual in Power BI. Here are a few possibilities:

    1. If you want to realize the result of multiplying two measures in the measure, the writing rule of the measure is very important, you need to check whether the measure uses ALL() or ALLEXCEPT() and so on, these functions can clear the filters of the data table or data columns and use the most primitive data for calculation.
    2. If it involves the use of multiple tables, please check the relationship between the two tables.

    If the above methods cannot solve the problem, please provide the data table and Measure involved, this will help me provide a more accurate solution.

    Here are some related links:

    powerbi - All rows and total of the rows showing same values in power BI - Stack Overflow

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum