Forum Discussion

mrbajana's avatar
mrbajana
Icon for Helper III rankHelper III
4 years ago
Solved

Mesure Group in One Row

It is possible to create a measure for a matrix that shows me for a single selected product and for several periods an evolution based on the last group but that keeps the history of the selected per...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, mrbajana 

     

    You can try the following methods.

    Measure:

    Cluster new = 
CALCULATE(MAX('Table'[Cluster]),FILTER(ALL('Table'),[Periodo]=SELECTEDVALUE('Table'[Periodo])))
    Value new = 
CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Periodo]=SELECTEDVALUE('Table'[Periodo])&&[Cluster]=[Cluster new]))

    Does this match the output you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, mrbajana 

 

You can try the following methods.

Measure:

Cluster new = 
CALCULATE(MAX('Table'[Cluster]),FILTER(ALL('Table'),[Periodo]=SELECTEDVALUE('Table'[Periodo])))
Value new = 
CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Periodo]=SELECTEDVALUE('Table'[Periodo])&&[Cluster]=[Cluster new]))

Does this match the output you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.