Forum Discussion

arad33's avatar
arad33
Frequent Visitor
3 years ago

Measure to filter on slicer

Hi Everyone    I have a sales report containing a measure that apportions all of the associated costs based on the percentage of our production time.   I have a slicer based on our Fiscal calenda...
Need Help
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
3 years ago

arad33  Have you tried ALLSELECTED(Date) ? If I understand correctly I think that should work for you??

arad33's avatar
arad33
Frequent Visitor
3 years ago

Thanks for the reply so if I take it to

 

Percentage Of ESH = DIVIDE(SUM(SalesReport[ESH Calc]),CALCULATE(SUM(SalesReport[ESH Calc]),ALLSELECTED(DimCYDate)))
 
This returns 100% across every line and apportions 100% of the costs across each line
  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    3 years ago

    arad33 Apologies, you'll also need to add a calculate modifier on the customer table too now (sorry I didn't read your requirements closely enough). Try:

     

    Percentage Of ESH = DIVIDE(SUM(SalesReport[ESH Calc]),CALCULATE(SUM(SalesReport[ESH Calc]),ALLSELECTED(DimCYDate)), ALL( CustomerDim ))