Forum Discussion

Ben_Kronk's avatar
Ben_Kronk
Frequent Visitor
5 years ago
Solved

Dynamic numerator based on slicer selections

I have a requirement for a Power BI dashboard and I'm not sure how to approach it, or if it's possible. I need a calculation where the numerator is dynamic based on the slicer selection, but the d...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    HiBen_Kronk,

     

    You can use the pattern below for the denominator. The ALL function removes the region filter, resulting in the total of all regions. The numerator is simply SUM ( [Amount] ).

     

    All Regions A/R =
CALCULATE ( SUM ( [Amount] ), ALL ( Regions ) )

     

     

DataInsights's avatar
DataInsights
Super User
5 years ago

HiBen_Kronk,

 

You can use the pattern below for the denominator. The ALL function removes the region filter, resulting in the total of all regions. The numerator is simply SUM ( [Amount] ).

 

All Regions A/R =
CALCULATE ( SUM ( [Amount] ), ALL ( Regions ) )

 

 

  • Ben_Kronk's avatar
    Ben_Kronk
    Frequent Visitor
    5 years ago

    Thank you!