Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Add Percentage Values based on External Sales.

Hi Experts   How would you amend the current DAX Measure to add percenatge value based on External Sale. into the Measure to Column so the data and percentage values are as the excel file attached....
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Solution to question the % values should take the following forum..

    2020 Full Year =
    VAR _external =
    SUMX (
    FILTER (
    ALL ( Logistics_ ),
    Logistics_[New_Reporting_Headers]="External Sales"
    ),
    [__v_Act2020]
    )
    VAR _Duty =
    SUMX (
    FILTER (
    ALL ( Logistics_ ),
    Logistics_[New_Reporting_Headers]="Duty"
    ),
    [__v_Act2020]
    )
    VAR _DutyPercentage =
    FORMAT(DIVIDE(_duty,_external,0),"0.0%;(0.0%)")
    VAR _Inbound_Freight =
    SUMX (
    FILTER (
    ALL ( Logistics_ ),
    Logistics_[New_Reporting_Headers]=
    "Inbound Freight"
    ),
    [__v_Act2020]
    )
    VAR _InboundPercentage =
    FORMAT(DIVIDE(_Inbound_Freight,_external,0),"0.0%;(0.0%)")
    VAR _Warehousing_Fixed =
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try one of the two measures

 

divide(calculate([measure 2], filter(Logistics_,Logistics_[new_Reporting_header] ="External sales")),[Measure 2])

 

 

divide(calculate([measure 2], filter(Logistics_,Logistics_[new_Reporting_header] ="External sales")),calculate([Measure 2], allselected(Logistics_)))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Amit - Any thoughts its not giving the values for the percentages???