Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Comparing Values from One Column to Another Sumarraizing

Hello,   I think this should be a straightforward probelm - but I can't figure it out!  I think some combination of variables and SUMMARIZE() will get me there but struggling to put it all together...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , try like


    countx(filter(table[Franchise Sales] >= table[Regional Average sales]),table[ franchiseID])
    sumx(summarize(Table,Table[franchiseID],"_1",sum(table[Franchise Sales]),"_2",sum(table[Regional Average sales])),if([_1]>=[_2],1,0))

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Your data is vague.  If the sale of Franchise ID 1 for 12/15/2018 was 54 (instead of 654), then would that Franchise ID be counted?  That same Franchise ID on 06/15/2018 reported a Franchise sale > Average sale.  On the date that you have shared, show the expected result very clearly.