Search code examples
powerbidaxmeasure

How to get Sum of Measure value in Power BI

was wondering if anyone knows how I can get the sum of a measure in Power BI. I have googled and tried different methods the entire day but it still doesn't work.

The table below shows my Measure, Resources divided by Count of Date 3, which equates to the number of resources per day =

DIVIDE(
    SUM('table'[Resource]),
    DISTINCTCOUNT('table'[Date])
)

However, now i want to get the sum of this measure i.e. get the sum of resources for the selected week but its not showing up correctly:

enter image description here

The total value should show up as 60.11 instead of 53.25.

Solution

  • You need to make this into an iterative measure:

    Additive Measure =
SUMX (
    VALUES ( 'table'[Parent_Project_Type] ), 
    [Your existing measure]
)

    OR with your new table name information:

    SUMX (
    VALUES ( as_mapops_resource_management[Parent_Project_Type] ), 
    [resource date level] // Note: this is a measure reference
)