Forum Discussion

Elmoataz's avatar
Elmoataz
New Member
3 years ago
Solved

Percentage based on a group

Hello, I'm trying to create a column that shows the percentage based on the other columns. For example; in the picture below I got the percentage of each of the materials based on the Order number us...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

     

     

    Percentage measure: =
IF (
    HASONEVALUE ( 'Order Number'[Order number] ),
    DIVIDE (
        [Amount measure:],
        CALCULATE ( [Amount measure:], ALL ( Material[Materials] ) )
    )
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

 

 

 

Percentage measure: =
IF (
    HASONEVALUE ( 'Order Number'[Order number] ),
    DIVIDE (
        [Amount measure:],
        CALCULATE ( [Amount measure:], ALL ( Material[Materials] ) )
    )
)