Matrix hierarchy grouping not showing data

[Sandritto]

Hi everyone,

I'm having trouble grouping data in a matrix. The matrix has two levels of columns, and a measure as values.

As you can see, with both levels deployed it shows data correctly. Trouble comes when I group up a level, it won't show any data. Like if there was something wrong with source data.

Here's a screenshot of the dataset, so you can see hierarchy has sense.

Congelado -- groups next 2 weeks.

Semiliquido -- groups from 2-6 next weeks.

Liquido -- groups from 7-8 next weeks.

Middle column is just for ordering purposes.

My goal is to get the average of the weeks im grouping. That's the simplest way I thought of doing it, maybe there's another way... creating another measure...

Any advice?

[parry2k]

@Sandritto what are you trying to calculate, it is not very clear? What measure you alredy created?

[Sandritto]

Hi @parry2k ,

I'm just trying to group VarianceA by Estado. But it won't show any data as you can see in the screenshot above.

The measure I created is VarianceA, which I'm using as values in the matrix.

Regards

[parry2k]

@Sandritto ok but is that measure expression?

[Sandritto]

Hi @parry2k ,

What do you mean by expression?

Here is the measure VarianceA:

Calculating variance between weeks.

Regards

[v-lili6-msft]

hi @Sandritto 

For your case, it related to row context in dax. 

https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin

[KEITHO]

Could you not put week of year in the row value?

Is there some reason that would not work for you?

[Sandritto]

Hi @KEITHO ,

There is. I don't want to show WeekofYear, just VarianceA grouped by Estado.

The result would be someting like this, with the correct values:

Regards

[KEITHO]

Ah ok.

I thought that if you put Estado in rows, and weeks underneath it, it will give you the sum of variances for each week, and you could change it from sum to average.