Reply
Topic Options
- 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
percentage from the parent column, regardless what is the parent column as it changes
12-14-2024
06:41 AM
I have date from 13 columns that user can change but they need the messure to caluclate the % from total an when they expand the expand be % of the parent not from the grand total tried the below and didnt work any ideas ,
% of Parent Total =
DIVIDE(
SUM(Table[MeasureColumn]),
CALCULATE(
SUM(Table[MeasureColumn]),
ALLSELECTED(Table)
)
)
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-14-2024
06:45 PM
This was impossible before Visual Calculations were introduced. Now it is trivial. read about COLLAPSE.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2024
04:36 AM
i want the expanded to be percentage from what is expanded from what the collapes do with that
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
10-16-2024 01:39 PM | |||
07-15-2024 06:09 PM | |||
07-05-2024 11:01 AM | |||
05-10-2023 07:53 AM | |||
07-09-2024 11:36 PM |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
1 |