Forum Discussion

DonPepe's avatar
DonPepe
Icon for Helper II rankHelper II
4 years ago
Solved

Dax Addition incorrect

Hi,   Do you know what is the cause of my false addition ? 35,00+3,00 is 38,00 not 38,75 or 38,21 or... See below : in HperOSP, I add OSPDur to Boni If I have a Y in the table. here the measure : ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi DonPepe ,

     

    Firstly, create a flag measure to filter the table:

    Flag = IF(MAX('CurrentWeek'[Activity Name])="Rust" && MAX('CurrentWeek'[RustBoni]) = "Y" ,1,0)
    OSPDur = CALCULATE(SUM(CurrentWeek[PLA Duration (seconds)]) /3600,FILTER(ALL(CurrentWeek), [Activity Name]<>"Rust"))
    Boni = [OSPDur]*0.6/7

    Output is the same as your Test table returns:

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

DonPepe's avatar
DonPepe
Icon for Helper II rankHelper II
4 years ago

Hi ,

 

Thanks for your time. 

 

I found the error and I have a granularity issue. 

 

So I have one ID who make several task with a certain durantion during his day and my measure should represent :

If when 'CurrentWeek'[Activity Name]="Rust", 'CurrentWeek'[Boni] = "Y" then [OSPDur]+[Boni] --the measure else [OSPDur] -- the measure

But I dont know how to translate it in DAX. 

 

here a sample of my data : 

ID Activity NamePLA Duration (seconds)RustBoni
CLD334Te voet ingang >< bureau12N
CLD334Laden6N
CLD334Laden1119Y
CLD334Traject Parking >< Kade - camion fix93N
CLD334Afleveren voertuig310N
CLD334Te voet Kantoor >< Voertuig185N
CLD334Sleutels, documenten en scanner teruggeven310N
CLD334Rust2700Y
CLD334Lossen1269N
CLD334Te voet Kantoor >< Voertuig180N
CLD334Sleutels, documenten en scanner teruggeven300N
CLD334Te voet ingang >< bureau0N

 

Thanks a lot,

 

Don

DonPepe's avatar
DonPepe
Icon for Helper II rankHelper II
4 years ago

Ok I found a way with a new calculated table. I would have prefered with a measure but I dont master DAX enough. 
Here the code of the new table :

Test = 
SUMMARIZECOLUMNS(
    CurrentWeek[ID],
    "BoniYN",
    IF(
        ISBLANK(
            CALCULATE(
                MAX(CurrentWeek[RustBoni]),
            CurrentWeek[Activity Name]="Rijden"
            )
        ),
        MAX(CurrentWeek[RustBoni]),
        CALCULATE(
            MAX(CurrentWeek[RustBoni]),
        CurrentWeek[Activity Name]="Rijden"
        )        
    ),
    "OSPDur",
    CALCULATE(
        SUM(CurrentWeek[PLA Duration (seconds)])/3600,
        CurrentWeek[Activity Name]<>"Rust"
    ),
    "Boni",
    ((
    CALCULATE(
        SUM(CurrentWeek[PLA Duration (seconds)])/3600,
        CurrentWeek[Activity Name]<>"Rust"
    )
    )*0.6)/(7)
)



Don