Forum Discussion

Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost Patron
7 years ago
Solved

Calculate by Age Range

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 pu...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

     

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
Fcoatis
Icon for Post Patron rankPost Patron
7 years ago

Thank you very much Lin.

 

I would never realized that.

 

Kind Regards,

 

Fabio