Forum Discussion
Calculation assistance with DAX
Hi, Need a assistance i have attached sheet from which i need the number of 1080 with DAX. sample is attached in below link https://we.tl/t-df1Fr6BUvN dax
what it is showing is the number of 2160 which is incorrect, it is showing other regions as well due to which it is calculating 2160
1080 number is correct which i have calculated manually in sheet 6.
So what i am looking that it should skip those regions who doesnt have the data in the sales sheet or show Zero working days if there is no working done.
v-chuncz-msft
Community Support
Community SupportAnonymous
You may add the measure below.
Measure =
SUMX (
SUMMARIZE ( Sheet1, Sheet1[Region Name], Sheet1[Brand] ),
CALCULATE (
DISTINCTCOUNT ( Sheet1[Interaction Date] )
* LOOKUPVALUE (
Sheet2[Head Count],
Sheet2[Region Name], SELECTEDVALUE ( Sheet1[Region Name] ),
Sheet2[Brand], SELECTEDVALUE ( Sheet1[Brand] )
)
)
)
Nope, even after adding this measure it doesnt calculate correctly. 834 it is showing in total :
the correct values are highlighted with green and the total of the measure is also different