Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Community - I have a simple table whereby I want to count the distinct count of Order #'s that are late, and the distinct count of Order #'s that are on time. For example, ABC-23 has two lines, but of course is just one order # so I only want to count it once.
Solved! Go to Solution.
Hi, @Anonymous
According to your description, I think you can create two measures.
Like this:
OnTime = COUNTX(FILTER(SUMMARIZE('Table',[Order],'Table'[Punctuality]),[Punctuality]="On Time"),[Punctuality])
Late = COUNTX(FILTER(SUMMARIZE('Table',[Order],'Table'[Punctuality]),[Punctuality]="Late"),[Punctuality])
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Hi, @Anonymous
According to your description, I think you can create two measures.
Like this:
OnTime = COUNTX(FILTER(SUMMARIZE('Table',[Order],'Table'[Punctuality]),[Punctuality]="On Time"),[Punctuality])
Late = COUNTX(FILTER(SUMMARIZE('Table',[Order],'Table'[Punctuality]),[Punctuality]="Late"),[Punctuality])
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
@amitchandak This unfortunate is not giving me the result I need. For example, if I create two measures, based on your measure (one for late, one for on time), and if I have multiple Orders selected in my filter, this is what I get. What I need is the total sum, by category (On Time or Late) of the Orders that fall into either of those categories. So, if there were 5 orders selected, two of them were late, and 3 on time, that should be reflected here.
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
96 | |
95 | |
56 | |
45 | |
42 |