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 all ,
i have below data in daily basis recorded by each transaction in 1st table.
and 2nd table is the result i want.
Currently i use the formula of distinct count which means when i filter 3 months together we lost some customers due to the same customer code is not counted. but what we want is , Total Distinct Customers by Month and then when the user filter 3 months together , it will count total distinct customers by each month together.
i have master table of calendar and Master Data as relationship.
Solved! Go to Solution.
1) Create the distinct count measure:
Customer Distinct count =
DISTINCTCOUNT ( Table[Customer Code] )
2) Use this final measure:
Final count of Customers =
SUMX (
SUMMARIZE (
'Calendar Table',
'Calendar Table'[Month],
"@bymonth", [Customer Distinct count]
),
[@bymonth]
)
Proud to be a Super User!
Paul on Linkedin.
Hi, @Chanleakna123
Please check the below picture and the sample pbix file's link down below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Chanleakna123
Please check the below picture and the sample pbix file's link down below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
1) Create the distinct count measure:
Customer Distinct count =
DISTINCTCOUNT ( Table[Customer Code] )
2) Use this final measure:
Final count of Customers =
SUMX (
SUMMARIZE (
'Calendar Table',
'Calendar Table'[Month],
"@bymonth", [Customer Distinct count]
),
[@bymonth]
)
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |