Percentage value of a row

[Anonymous]

I would like to get a % value of rows.

It can be in tooltip or in main visual.

For example in 1st row I need 1 - 20% and 4 - 80%

Currently PBI is calculating % values to the totals, so 1st row is like 1- 2,44% and 4 - 9,76%

How can I get this?

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

I have created a data sample:

If so want to show % of each [Name], you could simply use 100% Stacked Column chart.

Or as you mentioned, still use Stacked Bar chart , createa a measure for Tooltips , for example:

Measure = 
var _group=CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Name]))
var _subGroup=CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Name],'Table'[Type]))
return DIVIDE(_subGroup,_group)

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you @v-eqin-msft 

[PaulDBrown]

Assuming the Axis is from Table [field] and the measure displayed is [measure], try:

% per field =
VAR _field =
    CALCULATE ( [measure], ALLEXCEPT ( Table, Table[field] ) )
RETURN
    DIVIDE ( [measure], _field )