How do I accomplish summing multiple values then dividing by one value?

[Amrog]

How is this done in Dax?

[Greg_Deckler]

Depends on your data, if Met, Not Met, etc are measures then it is almost identical

( [Met] + [Not Met] + ... ) / [Denominator]

If that is not the case. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Amrog]

Hi Greg,

Thanks for the prompt response. "( [Met] + [Not Met] + ... )" are not meaures. I'm trying to replicate the formula from the Excel cell based format: 

=SUM(B12,C12,E12,F12)/H12

To what would be equivalent in Dax.

I tried creating a measure first:

Reporting Sum =

SUMX (

CaseMeasurePerformance,

CaseMeasurePerformance[NumeratorPass] + CaseMeasurePerformance[NumeratorFail] + CaseMeasurePerformance[NumeratorException] + CaseMeasurePerformance[NumeratorExclusion]

)

Then divide the measure by the denominator value, In excel this is the H12 cell:

Reporting Rate = DIVIDE( [Reporting Sum] , .... )

Intellisense will not allow me to divide by the value in the h12 cell.

I hope I provided some clarity.

Thanks, Aaron