Forum Discussion
Pzin
3 years agoNew Member
Help a starter - Counting Probelm
Hello Pros:), i just started with PowerBI i have my fair share of Failure during the last month. There is one result i would like to achieve which just won't work... I m gonna break it down to...
- 3 years agoTry the approach below. If it works for you, kindly mark this as a solution so anyone with similar issues can easily find it.
Measure =SUMX(
ALL(CustomersData[Customer]),
CALCULATE(
DISTINCTCOUNT(CustomersData[Date])
)
)
ahmedoye
3 years agoResponsive Resident
Try the approach below. If it works for you, kindly mark this as a solution so anyone with similar issues can easily find it.
Measure =
Measure =
SUMX(
ALL(CustomersData[Customer]),
CALCULATE(
DISTINCTCOUNT(CustomersData[Date])
)
)
ALL(CustomersData[Customer]),
CALCULATE(
DISTINCTCOUNT(CustomersData[Date])
)
)