Matrix component - order question

Hi, PowerBi is sitll a new tool for me... my comapny is changing from Tableau to PowerBi. Trying to migrate some Tableau's report to PowerBi I stucked in with matrix component. I need to create a...

Need Help

v-saisrao-msft
4 months ago
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.

danextian

Super User

4 months ago

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.