Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |