Forum Discussion

mrbajana's avatar
mrbajana
Helper 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.

parry2k's avatar
parry2k
Super User
4 years ago

mrbajana what you are referring a group? What is your expected output?

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

  • mrbajana's avatar
    mrbajana
    Helper III
    4 years ago

    The output is like this in the photo on the right side with the group 003 which is the last group that has the product but you can see the last selected periods in a single row