Single row Percentage of the Total based on all selected filters

[adelmonte]

Hi,
Would someone be able to help me with the percentage of Total per single row.
I would like to achieve in Power BI dynamically something that I can do in Excel manually.
Table is "Total Volume" column is "Delivered" I need to obtain the percentage as the formula next describes.
Avoiding 2 decimals after the percentage i.e. 17,02% -> 17%

Thanks,
Alex

[Anonymous · Accepted solution]

Hi @adelmonte ,

Please try below steps:

1. below is my test table

2. create a measure with below dax formula

Measure =
VAR cur_del =
    SELECTEDVALUE ( 'Table'[Delivered] )
VAR total =
    SUMX ( ALL ( 'Table' ), [Delivered] )
RETURN
    IF ( HASONEVALUE ( 'Table'[Delivered] ), DIVIDE ( cur_del, total ), 1 )

3. add a table visual with measure and fields

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.