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]))
    )
aduguid's avatar
aduguid
Icon for Memorable Member rankMemorable Member
2 years ago

In that case try these measures 

Dispatched Cogs = 
CALCULATE(
    SUM('YourTable'[Dispatched Cogs]),
    'YourTable'[Year] = SELECTEDVALUE('Year'[Year])
)

Total Dispatched COGS = 
CALCULATE(
    SUM('YourTable'[Total Dispatched COGS]),
    'YourTable'[Year] = SELECTEDVALUE('Year'[Year])
)

Dispatched Cogs Ratio = 
DIVIDE(
    [Dispatched Cogs],
    [Total Dispatched COGS]
)

 

ksharpes's avatar
ksharpes
New Member
2 years ago

Sorry still not working, I may have confused the issue slightly, for the [Total Dispatched COGS] I was using the calculation 

"calculate(sum('Amazon Week EPOS'[Dispatched COGS]), all())"
 
can the "Selectedvalue" art be included in the above?
 
"SELECTEDVALUE('Amazon Week EPOS'[Week End].[Year]) )"