Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi everyone
I've been looking around the community for something that might provide an answer to my problem. I have a Table hitorical Customer which display as below and I want to distinc Count Customer_Code by each month.
I tried create measure as below but didnot work
= TOTALYTD(COUNTDISTINC(CUSTOMER_HISTORY[CUSTOMER_CODE])),'DATE'[Date])
Thanks for your attentions. And appriciate to guide me to solve.
Solved! Go to Solution.
Hi,
I am not sure how your datemodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Customer Count measure: =
VAR _t =
SUMMARIZE (
FILTER (
CUSTOMER_HISTORY,
CUSTOMER_HISTORY[FROM_DATE] <= MAX ( 'Date'[Date] )
&& OR (
CUSTOMER_HISTORY[TO_DATE] >= MIN ( 'Date'[Date] ),
CUSTOMER_HISTORY[TO_DATE] = BLANK ()
)
),
CUSTOMER_HISTORY[CUSTOMER_CODE]
)
RETURN
COUNTROWS ( _t )
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,
I am not sure how your datemodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Customer Count measure: =
VAR _t =
SUMMARIZE (
FILTER (
CUSTOMER_HISTORY,
CUSTOMER_HISTORY[FROM_DATE] <= MAX ( 'Date'[Date] )
&& OR (
CUSTOMER_HISTORY[TO_DATE] >= MIN ( 'Date'[Date] ),
CUSTOMER_HISTORY[TO_DATE] = BLANK ()
)
),
CUSTOMER_HISTORY[CUSTOMER_CODE]
)
RETURN
COUNTROWS ( _t )
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.
Dear Jihwan_Kim
By refer to your solution, I worked with me, thanks
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |