Forum Discussion

likmalik's avatar
likmalik
Helper I
5 years ago
Solved

Mix 2 really simple formulas

Hello I'm using a formula to get the market share of car models and it works without problem.   Market share = DIVIDE ( SUM ( Sheet1[True Fleets] ), CALCULATE ( SUM ( 'Sheet1'[True Fleets]), AL...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    likmalik 

    Give this a try.

    Market share =
CALCULATE (
    DIVIDE (
        SUM ( Sheet1[True Fleets] ),
        CALCULATE ( SUM ( 'Sheet1'[True Fleets] ), ALL ( 'Sheet1'[Model] ) ) ) * 100,
    DATESBETWEEN ( Sheet1[Date], DATE ( 2020, 01, 01 ), DATE ( 2020, 12, 31 ) )
)
amitchandak's avatar
amitchandak
Super User
5 years ago

likmalik , Try like


CALCULATE ( DIVIDE ( SUM ( Sheet1[True Fleets] ),
CALCULATE ( SUM ( 'Sheet1'[True Fleets]), ALL( 'Sheet1'[Model]) ))*100, DATESBETWEEN(Sheet1[Date], DATE(2020,01,01),DATE(2020,12,31)) )