Count based on a condition by two Column

[ybatistamayo]

I want to count "Sales Key" only once when "DateKey" and "StoreKey" are equal. The count in this example should give 16

[Anonymous · Accepted solution]

@ybatistamayo 

There is only just another category of blank, can't you just +1?

Salidas =

IF(HASONEFILTER(DatosDiariosBasureros[IdVehículo]),DISTINCTCOUNTNOBLANK(DatosDiariosBasureros[SalidaBase]),DISTINCTCOUNTNOBLANK(DatosDiariosBasureros[SalidaBase])+1)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Does this measure work?

=COUNTROWS(SUMMARIZE(GENERATE(VALUES(Data[DateKey]),VALUES(Data[StoreKey])),Data[DateKey],Data[StoreKey]))

Hope this helps.

[ybatistamayo]

Sorry, it doesn't Work

[Ashish_Mathur]

Hi,

Shae the link from where i can download your PBI file.

[ybatistamayo]

https://1drv.ms/u/s!AoIRa67hIHkpgRI3N_1eDh7dBQlD?e=ta1NTd 

SalesKey = IdDatosDiarioBasurero

DateKey= SalidaBase
StoreKey = TurnoId

in this case the total count should give 17.
note there are blank values

[Ashish_Mathur]

Hi,

How did you arrive at 17 as the answer?  If you remove duplicates from the SalidaBase and TurnoId columns and filter out the blanks from the TurnoId column, you will be left with 931 unique row combinations.  Please explain clearly.  Alternatively post a simple example and show the expected result on that sample.

[Ashish_Mathur]

Hi,

Does the timestamp from the Salidabase column need to be considered or ignored?

[ybatistamayo]

Hi, the timestamp  is required