Forum Discussion

ksharpes's avatar
ksharpes
New Member
2 years ago
Solved

Total Sales % Card based on Slicer Selection

Hi All,    just started using Power BI so apologies if this is a basic question!   I have created a Card with the following formula to show a percentage of sales vs total Sales, but I would like ...
Need Help
  • ksharpes's avatar
    ksharpes
    2 years ago

    Thanks for the help, I have figured it out:

     

    Total Cogs % = DIVIDE(
        SUM('Amazon Week EPOS'[Dispatched COGS]),
        CALCULATE(SUM('Amazon Week EPOS'[Dispatched COGS]), ALLEXCEPT('Amazon Week EPOS','Amazon Week EPOS'[Week End].[Year]))
    )
ksharpes's avatar
ksharpes
New Member
2 years ago

Thanks for the help, I have figured it out:

 

Total Cogs % = DIVIDE(
    SUM('Amazon Week EPOS'[Dispatched COGS]),
    CALCULATE(SUM('Amazon Week EPOS'[Dispatched COGS]), ALLEXCEPT('Amazon Week EPOS','Amazon Week EPOS'[Week End].[Year]))
)