Measures

[alexbalazsalex]

Dear all,

Coming back with another Question:

lets say i have the following measure :

ActualQTD = CALCULATE([Actual], DATESQTD(Calendar[Date]))

Can i calucle the QTD for More columns within the  same measure? lets say actual is invoiced amount , but want it to calculate also pieces or tons without having to create another measure for each one:

Like below :

ActualQTD = CALCULATE([Actual], DATESQTD(Calendar[Date])) & CALCULATE([Pieces], DATESQTD(Calendar[Date])) & CALCULATE([ETC..], DATESQTD(Calendar[Date])) 

is it a way around it  as with & dont  think it will work

[v-ljerr-msft]

Hi @alexbalazsalex,

Can i calucle the QTD for More columns within the  same measure? lets say actual is invoiced amount , but want it to calculate also pieces or tons without having to create another measure for each one:

Like below :

ActualQTD = CALCULATE([Actual], DATESQTD(Calendar[Date])) & CALCULATE([Pieces], DATESQTD(Calendar[Date])) & CALCULATE([ETC..], DATESQTD(Calendar[Date])) 

---

So what result will the measure finally return? QTD for [Actual]+[Pieces]+[ETC..]? QTD for [Actual]*[Pieces]*[ETC..]? Or anything else?

Could you be more precisely with requirement by posting some sample data and the expected result, so that we can better assist on this issue? 

Regards