Forum Discussion
mrbajana
Helper III
Helper IIIMesure 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...
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
Super User
Super Usermrbajana 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.
