Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to get each row item of Extract Loss and divide it by the total sum of that column = % Contribution.
In this screenshot, I would need 388.91 / 670000.49, and then 2067.23 / 670000.49...
Solved! Go to Solution.
@Anonymous Try:
Measure =
VAR __ExtractLoss = SUM('Table'[Extract Loss])
VAR __AllExtractLoss = SUMX(ALLSELECTED('Table'),[Extract Loss])
VAR __Result = DIVIDE(__ExtactLoss, AllExtractLoss)
RETURN
__Result
@Anonymous Try:
Measure =
VAR __ExtractLoss = SUM('Table'[Extract Loss])
VAR __AllExtractLoss = SUMX(ALLSELECTED('Table'),[Extract Loss])
VAR __Result = DIVIDE(__ExtactLoss, AllExtractLoss)
RETURN
__Result
can you paste sample data like 5 rows
It can be done
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |