Repeat Information down column

[zimmermanaric]

I have the following developed (fake numbers of course to protect the innocent ). All of the data is in the same table. I am struggling with creating a formula that will ignore the labor expense category (which does not exists in the rows with generated minutes) so I can perform a calculation of LaborAmount:Total Generated Mintues.

[Greg_Deckler · Accepted solution]

Generally, you use an ALLEXCEPT filter in a CALCULATE to override the context of a measure within a visualization.

[v-qiuyu-msft · Accepted solution]

Hi @zimmermanaric,

As @Greg_Deckler suggested, you can create a measure:

Column 2 = CALCULATE(SUM(Table1[Labor Amount]),ALLEXCEPT(Table1,'Table1'[Parent Location]))

Also you can create a calculated column use:

Column = CALCULATE(SUM('Table1'[Labor Amount]),FILTER('Table1','Table1'[Parent Location]=EARLIER(Table1[Parent Location])))

Best Regards,
QiuyunYu

[Greg_Deckler · Accepted solution]

Generally, you use an ALLEXCEPT filter in a CALCULATE to override the context of a measure within a visualization.