Calculate by Age Range

[Fcoatis]

Hi,

In a sample data model as follows:

My fact table Venda (Sales) has 3 calculated columns :

Idade (Age)

Etaria (Age Range):

and Pos ( just for sort purposes). Im trying to calculate a matrix like this one:

But the measure (.Total Range) is not ignoring the Age Range filter. What am I doing wrong? All Ranges for each year , should be the Total for that year.

Thanks in advance.

Fabio Coatis

[v-lili6-msft]

HI, @Fcoatis

I have tested on my side, but not reproduce the issue. If possible, please share detail steps for us.

please share your sample pbix file and expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin

[Fcoatis]

Thank you for your reply.

Here is the link:

https://drive.google.com/drive/folders/1R45lnyJbHMW8SNPtzrVuSRBjfCPiPowX?usp=sharing

The result esxpected is :

Column12000Column22001Column3

Etaria	.Total	.Total Range	.Total	.Total Range
0-20	76.831	345.447	72.938	344.210
21-30	44.930	345.447	51.143	344.210
31-40	69.492	345.447	52.292	344.210
41-50	30.166	345.447	56.998	344.210
51-60	51.055	345.447	44.336	344.210
61-70	72.973	345.447	66.503	344.210
71-80		345.447		344.210
>80		345.447		344.210
Total	345.447		344.210

Thanks in advance

[v-lili6-msft · Accepted solution]

hi, @Fcoatis

After my test, this is due to Sort by Function, so you could use this formula:

.Total Range = CALCULATE([.Total],all(Venda[Etaria],Venda[Pos]))

Result:

Best Regards,

Lin

[Fcoatis]

Thank you very much Lin.

I would never realized that.

Kind Regards,

Fabio