Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
I have a modified data table as seen below for a Waterfall visual. This table is set-up to have an Attributes column that contains labels, and Values column that contains corresponding numeric values. Italicized columns for ValuePaid, TotalPaidTime and ValueTotal are additional measures that I have created.
LineSK | ValuePaid | TotalPaidTime | Attribute | Value | ValueTotal |
1 | Non Operating Time | 1220 | 13.93% | ||
1 | 7540 | Total Paid Time | 7540 | 86.07% | |
1 | 14 | Maintenance | 14 | ||
1 | 138 | Changeover | 138 | ||
1 | 160 | Clean / Sanitation | 160 | ||
1 | 947.18 | Other | 947.18 | ||
1 | 6280.82 | USLE | 6280.82 |
The table is meant to power two separate Waterfall charts. As such, I have created 2 measures as follows:
LineSK | ValuePaid | TotalPaidTime | Attribute | Value | ValueTotal |
527 | 7540 | Non Operating Time | 1220 | 13.93% | |
527 | 7540 | Total Paid Time | 7540 | 86.07% | |
527 | 0.19% | 7540 | Maintenance | 14 | |
527 | 1.83% | 7540 | Changeover | 138 | |
527 | 2.12% | 7540 | Clean / Sanitation | 160 | |
527 | 12.56% | 7540 | Other | 947.18 | |
527 | 83.30% | 7540 | USLE | 6280.82 |
Solved! Go to Solution.
HI @dhkhanna,
You can try to use the following measure formula to get the percent of 'current value' divided 'total value' and group by 'LineSK'.
ValuePaid =
VAR currAttribute =
SELECTEDVALUE ( 'Waterfall Table'[Attribute] )
VAR total =
CALCULATE (
AVERAGE ( 'Waterfall Table'[Value] ),
FILTER (
ALLSELECTED ( 'Waterfall Table' ),
'Waterfall Table'[Attribute] = "Total Paid Time"
),
VALUES ( 'Waterfall Table'[LineSK] )
)
RETURN
IF (
AND (
currAttribute <> "Total Paid Time",
currAttribute <> "Non Operating Time"
),
DIVIDE (
CALCULATE (
AVERAGE ( 'Waterfall Table'[Value] ),
VALUES ( 'Waterfall Table'[LineSK] )
),
total
)
)
Regards,
Xiaoxin Sheng
HI @dhkhanna,
You can try to use the following measure formula to get the percent of 'current value' divided 'total value' and group by 'LineSK'.
ValuePaid =
VAR currAttribute =
SELECTEDVALUE ( 'Waterfall Table'[Attribute] )
VAR total =
CALCULATE (
AVERAGE ( 'Waterfall Table'[Value] ),
FILTER (
ALLSELECTED ( 'Waterfall Table' ),
'Waterfall Table'[Attribute] = "Total Paid Time"
),
VALUES ( 'Waterfall Table'[LineSK] )
)
RETURN
IF (
AND (
currAttribute <> "Total Paid Time",
currAttribute <> "Non Operating Time"
),
DIVIDE (
CALCULATE (
AVERAGE ( 'Waterfall Table'[Value] ),
VALUES ( 'Waterfall Table'[LineSK] )
),
total
)
)
Regards,
Xiaoxin Sheng
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
17 | |
14 | |
12 | |
10 | |
9 |