DAX GENERATE ROW Results...How Do I Sum the Column of a "Generated Virtual" table?

[George2323]

Hi I am using Dax Studio and I have figured out how to get the calculation I need in the Output section of DAX Studio, but the output is in the form of a table.  I just need the sum of the column generated by using GENERATE and ROW.

I need the column in the red circle summed as that is the value I want for the metric in PowerBI. 

I have tried everything I can think of...new to DAX....searched high and low.  Just don't seem to be able to reference the "generated" table with any commands outside of the GENERATE ROW.

[daxer-almighty · Accepted solution]

// Very easy in fact...
// After the last RETURN
// you have to do:

sumx(
    DOHTable,
    [DOH]
)

// But I can't see a reason to use
// GENERATE for this when just
// ADDCOLUMNS would suffice or even
// just calculations on the fly under SUMX.
// For the calculation of the sum,
// of course, all the columns apart
// from DOH are not needed. By the way,
// the DAX standard is that all columns
// which are calculated in a measure/query
// should start with "@". Just to be able
// to differentiate them from physical columns
// and measures.

[George2323]

Yes. That worked. This wins a battle, but probably not the war on this project. I know there is a better way to do it, but this way was shown for "days of cover" by 2 DAX VIPs. You have to iterate through several weeks for a proper days on hand. 

[daxer-almighty]

Well, I would easily dare question their VIP-ness, LoL :)))