Forum Discussion

GCH_FR's avatar
GCH_FR
Helper I
2 years ago

SUM BETWEEN DIFFERENTS TABLES

Hello Everybody   Further to the help concerning my first topic (Re: How to do a calculation between date variable - Microsoft Fabric Community)   TEST BPA = SUMMARIZE(         FILTER(       ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

lbendlin , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:
Hi  GCH_FR ,

 

This should occur because [ANNEE_SEM]=2024-S01&&[CODIFICATION]="1-ORGANISATION" or ="2- CONCEPTION" are all on the the same date, which is treated as a group when calculating.

You can set an index for each row, and each row has a separate label for the separate grouping.

 

Here are the steps you can follow：

1. Add Column – Index Column – From 1.

2. Create measure.

 

Measure =
SUMX(
    FILTER(ALL('1-CALCUL TEMPS THEORIQUE BPA'),
    '1-CALCUL TEMPS THEORIQUE BPA'[Index]<=MAX('1-CALCUL TEMPS THEORIQUE BPA'[Index])),[TEMPS THEORIQUE BPA PAR JOUR])

 

3. Result:

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

GCH_FR's avatar
GCH_FR
Helper I
2 years ago

Hi Anonymous 

 

Thank you for your reply. It wasn't quite what I expected, but perhaps I wasn't very clear about what I wanted.

I found a solution by looking in different forums, the only problem is that my dates have to be sorted in descending order 

 

CALCULATE (
    SUM ( '1-CALCUL TEMPS THEORIQUE BPA'[TEMPS THEORIQUE BPA PAR SEMAINE] ),
    FILTER (
        ALL ( '1-CALCUL TEMPS THEORIQUE BPA' ),
        '1-CALCUL TEMPS THEORIQUE BPA'[CODIFICATION] = EARLIER ( '1-CALCUL TEMPS THEORIQUE BPA'[CODIFICATION] )
            && '1-CALCUL TEMPS THEORIQUE BPA'[Date] <= EARLIER ( '1-CALCUL TEMPS THEORIQUE BPA'[Date] )
    )
)
 

 

I've found a way to have my cumulative BPA / BPE / PRE by make a UNION between them

 

UNION(
    SUMMARIZE('1-CALCUL TEMPS THEORIQUE BPA','1-CALCUL TEMPS THEORIQUE BPA'[Date],'1-CALCUL TEMPS THEORIQUE BPA'[CODIFICATION],'1-CALCUL TEMPS THEORIQUE BPA'[TEMPS THEORIQUE BPA PAR SEMAINE]),
    SUMMARIZE('1-CALCUL TEMPS THEORIQUE BPE','1-CALCUL TEMPS THEORIQUE BPE'[Date],'1-CALCUL TEMPS THEORIQUE BPE'[CODIFICATION],'1-CALCUL TEMPS THEORIQUE BPE'[TEMPS THEORIQUE BPE PAR SEMAINE])
    )