Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Product cost % expense to total cost

  • 1.  Product cost % expense to total cost

    Gold Contributor
    Posted 11 days ago
      |   view attached
    Hi, Could you please help to derive the share (%) of expense to total cost, the % (category / total cost) is mentioned in the pbix but need a dax for the same

    Thanks

    ------------------------------
    FA
    ------------------------------

    Attachment(s)

    pbix
    % to total cost.pbix   24K 1 version
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Product cost % expense to total cost

    Bronze Contributor
    Posted 11 days ago
    Hi,
    Add this measure, it calculates percentage of each category in total.
    Measure = DIVIDE(SUM('Table'[Cost]),CALCULATE(SUM('Table'[Cost]),ALL('Table'[Category])))



    ------------------------------
    Nemanja Andic
    BI developer
    Belgrade
    ------------------------------

    Academy - Online Interactive Learning from Experts