How to Count Distinct in 2 requirement

[Wuttikorn]

Hi , All . I am a new member on this group . Nice to meet you. All. 

         I am trying to count distinct branch_no for Q1-2561 but it's not working. 

I just count only branch_no for Q1-2561  but not distinct branch_no

Ex.     Count(if([Quarter]='Q1-2561',[branch_no]))

Can anyone help me?     Thank you very much.

[Anil_Babu_Samineni]

Simply use set analysis like

Count(DISTINCT {<Quarter={'Q1-2561'}>} branch_no)

[PrashantSangle]

use keyword distinct.
1: Count({<Quarter={'Q1-2561'}>} Distinct branch_no)
2: Count(distinct if([Quarter]='Q1-2561',[branch_no]))

[Wuttikorn]

Thank you. loveisfail.

But I count only branch_no in year Q1-2561 that remove duplicated branch_no.

[Anil_Babu_Samineni]

You want without unique count? Try this to ignore Distinct statement

Sum({<Quarter={'Q1-2561'}>} Aggr(NODISTINCT Count({<Quarter={'Q1-2561'}>} branch_no),branch_no))

[Wuttikorn · Accepted solution]

Thank you for PrashantSangle.

This formula can use  :  Count(distinct if([Quarter]='Q1-2561',[branch_no]))

Thank you very much for you and all people. I am a beginner for Qliksense program. 

[Wuttikorn]

Thank you  loveisfail very much. I can use your formula to apply for another one.