Forum Discussion

zimmermanaric's avatar
zimmermanaric
Helper I
8 years ago
Solved

Repeat Information down column

I have the following developed (fake numbers of course to protect the innocent :smileyhappy:). 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.

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

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

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    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

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

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

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    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