Total from distinct values

Hi sixtoquiles

Try creating a measure over Target to be something like this

Sum of Target = CALCULATE(SUM('Table'[target]'))

From the data and description you have provided, this will result in a value of 23 once the filters on district and region have been set.

Well its simple you just have to create a measure and power bi will do the rest of it.

Please follow the steps

1. On the Dataset Right click and choose New Measure.

2. TotalTarget=SUM(<DatasetName>[Target])

Now this measure will be the total sum of the target value now all you have to do is just drag and drop it into the table

the table will group District and Region and show the TotalTarget with respect to it.

3. Drag and drop a table

4. In Field Choose District, Region and TotalTarget

5. Drop a Slicer and in field choose District, Region

Hi Phil_Seamark

i believe SUM('Table'[target]) will be sufficient.

is there any need of CALCULATE ???