Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Value and Distinct function giving same result

I am using two tables "Category" and "Product" Below is the output which I am getting: Ideally Distinct function should calculate the value excluding the blank. But here Value and...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Modify measure Products DISTINCT as below:

    Products DISTINCT = IF(MAX('Product'[Category]) in FILTERS(Category[category Id]),CALCULATE(DISTINCTCOUNT('Product'[Product])),BLANK())

    And you will see:

     

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

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

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  Anonymous ,

 

Modify measure Products DISTINCT as below:

Products DISTINCT = IF(MAX('Product'[Category]) in FILTERS(Category[category Id]),CALCULATE(DISTINCTCOUNT('Product'[Product])),BLANK())

And you will see:

 

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

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