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]))

mwegener's avatar
mwegener
Most Valuable Professional
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]))