Need to display Row Sub Totals

[Anonymous]

Hi Team

ROUND(IF([MAX_DT]<=SELECTEDVALUE(RetailAudit_StockCount[StockCount_CreatedDate]),CALCULATE(SUMX(RetailAudit_StockCount,[Face_On]),

FILTER(RetailAudit_StockCount,[Face_On]>=0))),2)

When I use above formulae. I am getting required  column sub totals working fine ... but not display or wrong Row Sub Totals

please Help me

Thanks

[v-diye-msft]

Hi @Anonymous 

Your capture is not complete for us to generate the determinate result. based on your formula. I'd like to make some change:

column = ROUND(IF([MAX_DT]<=SELECTEDVALUE(RetailAudit_StockCount[StockCount_CreatedDate]),SUMX(FILTER(RetailAudit_StockCount,[Face_On]>=0),[Face_On]),
,2)

If your problem still exists, please share us your dummy pbix or simple data with clear logic.

[Anonymous]

Thanks for your Reply

we are using live connection if max_ date then display Stock count 

we side create always messare only 

above measure working fine but didt display ROW total i think as per formula using DAX small restriction above please help

ROUND(IF([MAX_DT]<=SELECTEDVALUE(RetailAudit_StockCount[StockCount_CreatedDate]),CALCULATE(SUMX(RetailAudit_StockCount,[Face_On]),

FILTER(RetailAudit_StockCount,[Face_On]>=0))),2)

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Would you mind trying below formula?

Measure = var a = CALCULATE(SUM(RetailAudit_StockCount[Face_On]),FILTER(RetailAudit_StockCount,[Face_On]>=0)&&[MAX_DT]<=SELECTEDVALUE(RetailAudit_StockCount[StockCount_CreatedDate])
Return
Round(a,2)

If still not work, please kindly share your dummy pbix/simple worksheet.