You’re offline. This is a read only version of the page.
Good day,
I am trying to calculate the data for a column of data in PowerBI:
Below shows the sum of the items filtered (or sliced) for a date range. I would like to take the chks per row divide it by the sum and show in the %ofHch column.
eg: (237/88k)*100 =0.27%
try this measure
%ofHch = SUM(yourTable[chks]) / (CALCULATE(SUM(yourTable([chks]), ALL()))
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
