Not able to apply distinct count on mutiple criteria on column/measure

[Anonymous]

Hi folks,

I have to apply simple Distinct count formula based on mutiple criteria

Region	State	DB Code	DB Name	Channel Code	Flag	Channel
East	Assam	103393	ASHOK KUMAR JAIN & CO.(BLC-TINSUKIA)	5200	Prim	p>s
East	Bihar	103505	ASHOK UDYOG(BLC-FORBESGANJ)	5200	Prim	p>s
East	West Bengal	106652	RAMKRISHNA PAPER HOUSE (SILIGURI)	5200	Prim	Prim
East	West Bengal	1089	ASHIS KUMAR RUDRA(NAIHATI)	5200	Prim	p>s
East	West Bengal	11068	KALIMATA DIST.HOUSE(MOGRA)	5200	Prim	p>s
East	Jharkhand	11073	CSD Ramgarh	5400	Prim	p>s
East	West Bengal	1118	CSD Kolkata	5400	Prim	p>s
East	West Bengal	1128	DAMANI STORES-PURULIA	5200	sec	sec
East	West Bengal	1129	JANATA STATIONERY ST.(BLC)-RNGJ	5200	sec	sec
East	West Bengal	1134	SRI DURGA SALES AGENCY-BRKR	5200	sec	sec
East	West Bengal	122977	TARAMA AGENCY(BLC-JAGACHA)	5200	sec	sec
		Result Required
		prim=7
		Sec+P>s=10

I am very sad about Power BI  behaviour. it is not allowing the flexibility as tableau. Tablea is far better than PBI

Request you guys please help me

[dedelman_clng · Accepted solution]

Hi @Anonymous  - you're not very clear about what you're trying to do, but here's how to get the results you are looking for:

Prim = COUNTROWS(FILTER(Table2, Table2[Flag]="PRIM"))

SecOrPgtS = COUNTROWS(FILTER(Table2, Table2[Channel] in {"P>S", "sec"}))

If that is not what you're looking for, please expand on the description of what you are trying to do.

Hope this helps

David

[Anonymous]

Hi David,

Thanks for reply.

I have resolved this myself

Pri_DB_Count = CALCULATE(DISTINCTCOUNT('db_CSA_Data Yield_Sec_Test'[DistributorCode]),FILTER('db_CSA_Data Yield_Sec_Test','db_CSA_Data Yield_Sec_Test'[Primary/Secondary]="Primary"))

Sec_DB_Count = CALCULATE(DISTINCTCOUNT('db_CSA_Data Yield_Sec_Test'[DistributorCode]),FILTER('db_CSA_Data Yield_Sec_Test','db_CSA_Data Yield_Sec_Test'[ChannelName]<>"5200"))

Thanks