measure not sum correctly in Total

[Anonymous]

Hi, 

i created a measure to countrow dax in my dashboard.It works but not in the Total. Do i miss anything in the DAX?

DAX: 

COUNTROWS(

FILTER(

ADDCOLUMNS(

CROSSJOIN( VALUES( '03 Calander Table'[Date] ), VALUES( 'Inventory Trend'[Material Number] ) ),

"Inventory Levels",[Total RunSum] ),

[Inventory Levels] = 0 && NOT( ISBLANK( [Inventory Levels] ) ) ) ) +0

[mahoneypat]

You probably want different aggregation depending on the column, but you can use this same pattern.  Not sure what your other Row header column name is.

MeasureToGetCorrectTotals = SUMX(SUMMARIZE(Table, Table[Plant Code], Table[Other Column Used in Row]), [Your Existing Measure])

You can use AVERAGEX instead of SUMX to (e.g., like for percentage measure).  Make this measures referencing your existing measures and then used the new ones to replace the existing ones in your visual.  You should get correct #s on the rows and in the totals.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat