Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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] ) )
)
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |