Adding two non-aggregated columns to an aggregated matrix

[wfarrell]

Hello!

I am trying to add two columns to an existing matrix. My issue is that the two columns that I want to add are NOT going to be aggregated. I have one row of values for each date, therefore no need to aggregate i.e. Sum, Average, etc.  Below is a screenshot of the matrix and the two columns that I want to add to the matrix.  I would like my final matrix to have the following columns:

Weekly        DATE        Unique Dials      Total Dials          Leads        Cost

[MungBurger]

@wfarrell 

This was the solution that worked for me.

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax

The only limitations are that it can only be used in Azure AS or in the Power BI Service.

This came out in Nov 18 and Kasper notes that there was no existing functionality to replicate the behaviour.

Could be time to revist your measures if it suits your scenario.

Regards

[v-yulgu-msft · Accepted solution]

Hi @wfarrell,

It is a default behavior that any field added to values section of Matrix has to be aggregated. Since in your source table, there is only one date row for each date, whether it is aggregated with Sum or Max or Average, the displayed result is the same as original data which is not aggregated in table.

Regards,

Yuliana Gu