Summation of measure field across groups

[pieterhkruger]

Hi,

In the following table, the values in the last column are calculated values (based on the two columns to the left, that are also calculated measures).  I now want to obtain the sum of them by date, e.g.: 2.62+0.37+4.22 for 2017-01;  2.05+0.44+3.50 for 2017-02, etc.

Eventually I want the sum totals per date, without having to display the breakdown by category (VAR_CATEOGRY column) in the table.

I have no idea how to proceed.

Is there a way to share the PBIX file?  Or should I share the data format & DAX formulas used for all the measures?

[az38]

Hi @pieterhkruger 

you could share your pbix-file to third-party cloud like https://uploadfiles.io/ and share thelink here

for your task maybe it would be enough to use ALLEXCEPT() statement like

Measure = 
CALCULATE(SUM([Stability Index Factor), ALLEXCEPT('Table', 'Table'[DEV REC Capture month]))

do not hesitate to give a kudo to useful posts and mark solutions as solution

[pieterhkruger]

Hi,

I've uploaded another file:  http://ufile.io/sfw9aa90

What I've tried to do in this newly uploaded file is to create a table using DAX, replicating what I've done in the individual measures.  As a result I get exactly what I want (see below), but with one major problem: it remains static, i.e.:  it is unaffected by selections from the slicers.  So, if there is a way to get the DAX-created table to be affected by selections on the slicers, then I have my solution ...

[pieterhkruger]

Thanks.

I have uploaded the PBIX-file to: https://ufile.io/ztr3elwa

The option SUM([Stability Index Faxtor]) does not work, presumably because [Stability Index Faxtor] is a calculated field.