Forum Discussion
Measure returning correct total but row value is incorrect
I have a dataset with multiyear data. See sample below. Year Region Employees Primary Key 2020 West Employee1 2020WestEmployee1 2020 East Employee2 2020EastEmployee2 2020 Wes...
Hi v-weiyan1-msft thanks for your response. The dax you provided for Min (and Max) populates 0 when the count is blank.
There's something I didn't include in my initial post - the regions are grouped and with the new dax, the subtotals and totals are inaccurate, and I'm looking to achieve what's shown in the table below.
| Region | 2020 | 2021 | 2022 |
| Group A | 2 | 3 | 3 |
| North | 0 | 2 | 2 |
| South | 2 | 1 | 1 |
| Group B | 3 | 2 | 3 |
| East | 1 | 1 | 1 |
| West | 2 | 1 | 2 |
| Total | 5 | 5 | 6 |
Can you assist with this? Much appreciated!