Forum Discussion

AmeenVanakar's avatar
AmeenVanakar
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Values in calculated column do not filter according to date selected - Need Help

Hi, I have created a calculated table to show unique customers (customer mobile number), their unique visits (number of unique invoices), and a group based on their number of visits.   I have also...
Need Help
AmeenVanakar's avatar
AmeenVanakar
Icon for Advocate II rankAdvocate II
1 year ago

Hi _AAndrade 

Thanks for your update.

Customer 3165296135 should be excluded in this case under the column "Sum of Unique Invoices" as he/she had only 1 visit between 8/1/2024 to 9/23/2024. Is there a way to do this?

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ALL

Firstly  _AAndrade thank you for you solution! 

And AmeenVanakar ,As you said When Customer 3165296135 has only one visit in the selected date, we exclude him, that is, we show blank value, you can use the following DAX, which can help you to exclude Customer IDs that have only one visit record, I hope it will be helpful for you!

Sum of Unique Invoices = 
CALCULATE(
    DISTINCTCOUNT(Customer_Data[BILL NO]),
    FILTER(
        VALUES(Customer_Data[CUSTOMER MOBILE NO]), 
        CALCULATE(
            DISTINCTCOUNT(Customer_Data[BILL NO]) > 1
        )
    )
)

 

If you have further questions, you can contact me at any time, I will reply to you at the first time after I receive the message, looking forward to your reply!

Hope it helps!

 

Best regards,
Community Support Team_ Tom Shen

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.