Forum Discussion

tcaselli's avatar
tcaselli
New Member
7 years ago
Solved

Problem with filtered measures and sums

Hi, I'm having a problem crating a measure that works for my dataset. Here's what it looks like:   Date     #Rejected    #Produced   #RejectReason 8/1          4                   7               ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi tcaselli 

    If i understand you correctly, you could create a measure as below

    reject_reason_date = CALCULATE(SUM('Table'[Rejected]),ALLEXCEPT('Table','Table'[RejectReason],'Table'[Date]))

produced_date = CALCULATE(SUM('Table'[Produced]),ALLEXCEPT('Table','Table'[Date]))

percentage = [reject_reason_date]/[produced_date]

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi tcaselli 

If i understand you correctly, you could create a measure as below

reject_reason_date = CALCULATE(SUM('Table'[Rejected]),ALLEXCEPT('Table','Table'[RejectReason],'Table'[Date]))

produced_date = CALCULATE(SUM('Table'[Produced]),ALLEXCEPT('Table','Table'[Date]))

percentage = [reject_reason_date]/[produced_date]

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.