- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hierarchy of calculated measures
Hi everyone,
I have a table in my Power BI Desktop with a lot of calculated measures I have created. Many of them have some kind of relation, so it would be really helpful if there is a possibility to create some Hierarchies in the table that group the related measures.
Is this posible?
Thanks a lot!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What do you mean "have relation between measures"?
In Power BI Desktop, it's not possible to create a hierarchy/folder to group measures. You should create hierarchy on dimension members and only measure for corresponding fact data which can be sliced by the hierarchy. For example, you can create a calendar hierarchy like "Year->Quarter->Month->Date" to slice a Sales measure.
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is this can be achieved on 2023?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can group measures in specific tables.
1.- Create a blank query in the query editor.
2.- Rename it to something that makes sense to you like "Measures for Accounts" or "Average Measures"
3.- Move the measures to the corresponding tables by changing their Home Table in the modeling tab in Power BI Desktop.
That doesn't make measures hierarchies, but will let you group them in meaningful tables. Hope it helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That will not help you in using the group as some sort of group in the vizualisation, not?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What do you mean "have relation between measures"?
In Power BI Desktop, it's not possible to create a hierarchy/folder to group measures. You should create hierarchy on dimension members and only measure for corresponding fact data which can be sliced by the hierarchy. For example, you can create a calendar hierarchy like "Year->Quarter->Month->Date" to slice a Sales measure.
Regards,

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-27-2024 05:56 AM | |||
07-25-2024 06:40 AM | |||
07-28-2024 01:06 PM | |||
Anonymous
| 05-16-2024 07:09 AM | ||
07-24-2024 09:57 PM |
User | Count |
---|---|
121 | |
102 | |
88 | |
52 | |
46 |