Forum Discussion

MAAbdullah47's avatar
MAAbdullah47
Helper V
9 years ago

Distinct Count not working

Dear All, I visited the following post: http://community.powerbi.com/t5/Desktop/how-to-count-distinct-values-in-a-column/m-p/183518#M80566   When I create Measure the function Distinct Count workin...
Need Help
MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

Based on the information you provided, it can be anything.

 

So my advice is to provide more information, like what formula do you use, what is the actual result, the expected result, why and any other specific information that increases the odds of you getting the help you are looking for.

MAAbdullah47's avatar
MAAbdullah47
Helper V
9 years ago

Here Is the formula: 

 

Number Of Orders In Branch = CALCULATE(DISTINCTCOUNT(Branch_Order_Size_1[Order No])) (Correct Result if it is inside Measure)

 

Same formula:

 

No Of Orders In Branch = CALCULATE(DISTINCTCOUNT(Branch_Order_Size_1[Order No])) (Wrong Result if it inside Column) ,

 

I need it based on a column cuz If it is a measure I want to divide it by the Total Sales:

 

Avg Price Sales = Branch_Order_Size_1[Total Sales]/sum([Number Of Orders In Branch]) ----> Not Work cuz it is measure not column

 

For this I need it to be in a column not measure, you got the point?