Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## DistinctCount IF?

Hi All,

I'm new to Power BI (and DAX) coming from Tableau.

I've got a question regarding the DiscountCount function.

I need to calculate a percentage of orders that include a certain item. The way my data is structured is line items on every order for the last year. (Example: If one order has three items on it, three lines are returned for that order each line with a specific item).

I'd like to create a measure that give me the sum of a distinct count of order numbers but only if they include a certain item number. I can't use the filter function because I'd need to compare the afore mentioned measure to a count of all distinct orders.

This seems like something that should be very doable, I'm just can't wrap my head around it yet.

Thanks!

PS - Does anyone have any good resources (perferably books) that can get me into the swing of using DAX and Power BI?

1 ACCEPTED SOLUTION
Resident Rockstar
```CALCULATE(
DISTINCTCOUNT( FactOrder[OrderNumber] )
,FactOrder[Line Item] = <certein item number>
)```
6 REPLIES 6
Resident Rockstar
```CALCULATE(
DISTINCTCOUNT( FactOrder[OrderNumber] )
,FactOrder[Line Item] = <certein item number>
)```
Frequent Visitor

@greggyb  @KHorseman  I am trying to use your formula, but i am not sure where I am doing a mistake

want to calculate distinct job number on gloss pack option or body colour option

Here is the error

Frequent Visitor

@greggyb  Can you please tell me where i am doing wrong, I tried to use your formula

Anonymous
Not applicable

Worked perfectly! Thank you so much!

Community Champion

If you want to understand the reason behind that answer, check this out: http://www.powerpivotpro.com/2009/12/powerpivot-dax-calculate-is-a-supercharged-sumif/

Actually the title of that blog post is slightly misleading; CALCULATE is a supercharged WHATEVERIF. COUNTIF, SUMIF, DIVIDEIF, etc. depending on what kind of expression you feed into it. That whole blog is a fantastic resource for learning DAX, and they've got a great book as well.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Anonymous
Not applicable

Thank for the resource, I really appreciate it!

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors