Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Formula

Hey y'all, greetings! I am facing issues developing this DAX formula. My case is that I created one measure like this: Measure A = (SUM(Field A) / SUM(Field B)). It is working pretty well but now,...
Need Help
  • mwegener's avatar
    mwegener
    7 years ago

    Hi Anonymous

     

    i think you should summarize you table

     

    SummarizeTable = SUMMARIZE(Table2;Table2[C];"A";DIVIDE(SUM(Table2[A]);SUM(Table2[B])))

    ... and make you calculation on the summarized table.

     

    Measure = DIVIDE(SUM(SummarizeTable[A]);COUNT(SummarizeTable[C]))

AlB's avatar
AlB
Community Champion
7 years ago

Hi Anonymous

I'm having a bit of a hard time trying to understand what you need

What is Field C?

What you show (below), is it a table? Measure A is a column of that table??

 

                 A           B           Measure A                 
Sale 1: 27,00     20,00                     1,35
Sale 2: 30,80     70,00                     0,44

 

I'm really going out on a limb here but maybe what you need is:

 

SUMX(Table; [Column A] / [Column B] )  / COUNTROWS(Table)