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 =
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Morning Henry I have solved the question ill post solution later on - IT issues...

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,


If this problem has been resolved, you can mark yourself or delete this post.🙂

Best Regards,
Henry