Forum Discussion
cannot aggregate measure
Hi there,
I ve got a problem with measure dax. I cannot sum in group from measure which I ve created.
First I create a calculated column
totalday= (DATEDIFF(UW[Hieuluc Tu],UW[Hieuluc Den],DAY)
then I created a measure as below
earned_day = (CALCULATE(COUNTROWS('Date'),FILTER('Date','Date'[Date] >=MIN(UW[Hieuluc Tu]) && 'Date'[Date] <= MIN(UW[Hieuluc Den]))))/MIN(UW[totalday])
It's righ for each row calculation but when I do a sum for the year it's not correct anymore.
Do you have any idea?
Thanks for all!
4 Replies
- AntrikshSharma
Community Champion
See if this works:
earned_day = SUMX ( VALUES ( 'Date'[Year] ), DIVIDE ( CALCULATE ( COUNTROWS ( 'Date' ), FILTER ( ALL ( 'Date' ), 'Date'[Date] >= MIN ( UW[Hieuluc Tu] ) && 'Date'[Date] <= MIN ( UW[Hieuluc Den] ) ) ), VAR MinTotalDay = MIN ( UW[totalday] ) RETURN IF ( MinTotalDay = 0, 1, MinTotalDay ) ) )The reason for infinity error is because at the denominator there is 0 for 2020 so you will have to check for the 0.
Thanks for your reply
Your dax can fix the infinity problem but it still doesnt correct the total of row. I need to calculate the total by year. I cannot use sum function for a measure. The first measure just calculate for each row and I dont know how I can aggregrate for a group.
- AntrikshSharmaCan you please upload the file to google drive/one drive/dropbox and share the link and mark what values you want at the each row in the visual.
