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.
Here is the dataset:
Year Type Value
2023 | a | 20 |
2023 | b | 50 |
2023 | c | 30 |
Here is the Visual: I want to see percentage when hover over a category:
Here is how to make the visual:
Here is the DAX I used to make the code:
Measure =
var a = sum('Table'[Value])
var b = if(HASONEVALUE('Table'[Type]), max('Table'[Value]) )
return b / a
But the result does not show an accurate percentage when hovered:
Expected result: 30/100 = 30% and not 100%
Solved! Go to Solution.
Hi @bipowerbix
Please try
Measure =
DIVIDE (
SUM ( 'Table'[Value] ),
CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Type] ) )
)
Hi @bipowerbix
Please try
Measure =
DIVIDE (
SUM ( 'Table'[Value] ),
CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Type] ) )
)
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 |
---|---|
55 | |
25 | |
23 | |
14 | |
11 |
User | Count |
---|---|
78 | |
63 | |
47 | |
17 | |
12 |