Removefilter on sum

[Anonymous]

Hello I have the below measure. The results in my matrix are fine until I add a filter in the filter menu for the quantity. 

Mesure2 =

calculate(

DISTINCTCOUNT('Juin 2020'[Order]),

REMOVEFILTERS('Juin 2020'[Product Code],'Juin 2020'[Order]),

ALLSELECTED('Juin 2020'[Date]))

I tried to add 'Juin 2020'[Quantity] in Removefilters but it is not working. I think it doesn't recognize the fact that it is a sum. What can I do? Thank you

[Anonymous · Accepted solution]

I found the problem. Couting dates with hours in the creates problem. Don't do that!

[VahidDM]

Hi @Anonymous 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/