Forum Discussion

zimmermanaric's avatar
zimmermanaric
Helper I
9 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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

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