Total Rows by Hierarchy Data Column

[ghutchins]

I am trying to sum up values in for a row across eventually  12 date columns in the last table.  The values are calculated measures from other data columns.  I cannot seem to get over this hurdle and hope there is help out there somwhere.   Any help is appreciated be it a resouce or suggested code.

 

[Mikelytics · Accepted solution]

HI @ghutchins 

Without seeing the data model I have to do some assumptions but it should be something like this:

Final Measure = 
SUMX(
   VALUES(DateTable[Month]),
   [Count MA > 4 (Count)]
)

Do you use a proper date table?

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

[Mikelytics · Accepted solution]

HI @ghutchins 

Without seeing the data model I have to do some assumptions but it should be something like this:

Final Measure = 
SUMX(
   VALUES(DateTable[Month]),
   [Count MA > 4 (Count)]
)

Do you use a proper date table?

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

[ghutchins · Accepted solution]

Thanks your suggestion lead me to the answer...  

Count MA > 4 (Count all) =

SUMX(

   VALUES('GoodCatch Data'[submitted_date].[Month]),

   [Count MA > 4 (Count)]

)