Forum Discussion
Matrix component - order question
Hi Bartek_Smith,
Please provide PBIX that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data?https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI…
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/144…Thank you.
Hi Bartek_Smith
Currenly, measures are always at the lowest level of the hierahcy. The workaround is materialize the measures in a disconnnected table and reference that table in a conditional measure to return the desired value.
Please see the attached sample pbix.
Is this solution efficeint? If I good understand I need to do a copy of my orginal table measures.
My source has aroud 800k records sa i double themHi danextian.
This is a good soluction, but it will also increase model size.
Is there a better solution? using visual calculations maybe.
It wil increase the model size but the change should be negligible. You are not creating another table containing the results of your measures but simply a table that holds the measure names. If there are two measures, you will be creating a table of two rows only.
