Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
then I created a measure as below
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |