cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Peter_Sun
Frequent Visitor

Distribution Point Calculated on Power BI

Hi All, 

 

Could anyone help me solve below business scenarions? 

 

Distribution Point Definition: One product sold to one customer with real purchasing value amonnt ( we might send customer samples for free and this of couse won't be calculated as DPs) called One DP. 

 

I need to use a DAX to do this calculation. 

 

I tried to use DISTINCTCOUNT Function, but it could only tell me how many products are sold per month, or how many customers we have per month. I need sort of combing them altogether. 

 

I could do this in Excel using Countif  as below (1) and came out the DPs as (2)

On below tables (3) is customer name and (4) is products purchased by this customer. 

 

DPs.PNG

 

We might want to know how many DPs we are having per month or per quarter. 

 

Really Appreciate if anyone could solve me this puzzle. 

 

Thanks,

Peter Sun 

2 REPLIES 2
Super User IV
Super User IV

Re: Distribution Point Calculated on Power BI

If you can post some sample raw data I can be more specific. Otherwise, the general replacement for COUNTIF in DAX is CALCULATE like so:

 

Measure = CALCULATE(COUNT([Column]),FILTER(Table,[Column/Measure] > 0))

Something along those lines.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Highlighted
Peter_Sun
Frequent Visitor

Re: Distribution Point Calculated on Power BI

Thanks for your quick reply 

 

And please see below raw data and it is quite falt comparing with pivot table. 

If only used below calculated measure, it would only get the how many products are sold, right?

 

Can you please help me? Thanks 

 

 DP Raw Data.PNG

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors