topic Trying to CREATE percentage as tooltip when I Hover on bar graph in DAX Commands and Tips

Trying to CREATE percentage as tooltip when I Hover on bar graph

bipowerbix — Tue, 14 Mar 2023 05:52:59 GMT

Here is the dataset:

Year Type Value

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%

tamerj1 — Tue, 14 Mar 2023 06:26:27 GMT

Hi bipowerbix
Please try

Measure = DIVIDE ( SUM ( 'Table'[Value] ), CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Type] ) ) )

Anonymous — Tue, 14 Mar 2023 07:02:23 GMT

% = DIVIDE(sum('Table'[Value]), CALCULATE(SUM('Table'[value]),all('Table'[Type])))

try this one.