Forum Discussion
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 periods in a single row and shows only the last group.
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.
5 Replies
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.
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
mrbajana ok, then use matrix visual,
add cluster on rows
add period on column
add value on values
and that will do it.
✨ 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.
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.
