Forum Discussion

bins007's avatar
bins007
New Member
2 years ago
Solved

PowerBI Dax - Division

Hello, I'm struggling to create DAX to display the following: I want to divide every value in column 'consumedunits' to the grand total of the same column. To give a better understanding, I used exc...
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    bins007 , Yesterday I replied to similar problem, first you need to create a measure using calculate and All for total value

     

    TotalCaseFullRef = CALCULATE(SUM('Case Details'[CaseFullRef]), ALL('Case Details'))
    Replace Case details with your table name and Case Full ref with column name
     
    Then create one more measure for percentage 
     
    DAXPercentageOfTotal =
    DIVIDE(
        SUM('Case Details'[CaseFullRef]),
        [TotalCaseFullRef],
        0
    )
     
    Attaching PBIX for reference
  • Anonymous's avatar
    Anonymous
    2 years ago

    Please check it. Its a simple division.

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

bins007 , Yesterday I replied to similar problem, first you need to create a measure using calculate and All for total value

 

TotalCaseFullRef = CALCULATE(SUM('Case Details'[CaseFullRef]), ALL('Case Details'))
Replace Case details with your table name and Case Full ref with column name
 
Then create one more measure for percentage 
 
DAXPercentageOfTotal =
DIVIDE(
    SUM('Case Details'[CaseFullRef]),
    [TotalCaseFullRef],
    0
)
 
Attaching PBIX for reference