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.
Hi
I need some help..
I have a table
Date(Bins) Type A Type B Type C RowTotal (I created this measure adding the row)
Jan 2016 30 276 342 648
Feb 2016 24 269 307 600
Mar 2016 41 332 286 659
I need to be able to add columns Type A % of RowTotal
Type B % of Row Total
Type C % of Row Total
and display that in 3 columns for each of the months or rows like shown above
Anyhelp? Thanks in advance
@ridercos wrote:
Hi
I need some help..
I have a table
Date(Bins) Type A Type B Type C RowTotal (I created this measure adding the row)
Jan 2016 30 276 342 648
Feb 2016 24 269 307 600
Mar 2016 41 332 286 659
I need to be able to add columns Type A % of RowTotal
Type B % of Row Total
Type C % of Row Total
and display that in 3 columns for each of the months or rows like shown above
If that is a table visual, I think you can create 3 measures as below. The [RowTotal] is the measure you already created.
Type A % = SUM(yourTable[TypeA])/[RowTotal]
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |