Forum Discussion
Support for a Calculation
- Anonymous2 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:
- 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.
- 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 TeamIf 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
Hi Anonymous
Total Revenue = 438489
Total Cost= 82514
Cost% = 18.8
Total Labour Cost by Category =
CALCULATE(
SUM('Sales'[LabourCost]),
ALLEXCEPT('Sales', 'Sales'[Category])
)
Whatever are the names of your columns and tables, use them as per your choice.