Forum Discussion
Simple Calculation Required - DAX formula
I have quite a simple query I've made a dashboard without having to use DAX. I've now hit a wall and through my research I think I need to use a DAX formula. I've never used this before so your ...
Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).
| Column1 | Column2 |
| A | 1 |
| B | 2.5 |
based on what you wrote, and assuming everything is in one table, something like this should work:
Measure = CALCULATE(SUM('Table'[Unit cost]), ALL('Table'[City]))it negates the filters you put on the cities, so it should give the total per country