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
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] )
)
)
)