Forum Discussion

SuperSayan's avatar
SuperSayan
Resolver I
8 years ago
Solved

Count rows depending on a condition

Hello everyone,   I have an issue that I can't figure out.   I'm trying to count the numbers of lines in a table where there is no date (actually value is 0 so the date is 01/01/1900) and then I'...
Need Help
  • SuperSayan's avatar
    SuperSayan
    8 years ago

    Hi v-yulgu-msft and Greg_Deckler

     

    I really have to apologies to both of you! 

    I just realized where this issue comes from... I had put a filter on the whole report that was filtering all lines with dates <2000 (therefore including the 1900) which resulted in not showing anything in my measure.

     

    I removed the the filter and now it works.

    I feel a bit stupid after that....

     

    Thanks again for taking the time to help on a "non existing" issue!

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi SuperSayan,

 

Based on my test, below formula works for append table, too.

RestantaFaire = COUNTROWS(FILTER(HistoriqueInter;HistoriqueInter[FinréelleDateH].[Année]=1900))

 

How did you append the two tables? In my test, I appended them in Query Editor mode using the "Append queries as new" option.

 

Regards,
Yuliana Gu

SuperSayan's avatar
SuperSayan
Resolver I
8 years ago

Hi v-yulgu-msft and Greg_Deckler

 

I really have to apologies to both of you! 

I just realized where this issue comes from... I had put a filter on the whole report that was filtering all lines with dates <2000 (therefore including the 1900) which resulted in not showing anything in my measure.

 

I removed the the filter and now it works.

I feel a bit stupid after that....

 

Thanks again for taking the time to help on a "non existing" issue!