Measure values are repeating in table

[NarenderMakhija]

Hi Team,

I have a table that have fileds -  [Rec Year Month],       [No of Filter]   ,      [Received Date]

I am showing them in power Bi table and it is repeating value of "2021-Jan" in each Rec Year Month. Below is my measure

Filer not null = calculate(DISTINCTCOUNT(Stage1_BI_Filers[NO_OF_FILERS]),FILTER(Stage1_BI_Filers, Stage1_BI_Filers[RECEIVED_DATE]<>"NUL"))

But in sql i am getting rught data.

In power Bi i am getting count 11147 in each [rec year month] but in sql jan-2021 has count 11147 and Feb-2021 has count 11821.

thatmeans in power bi it is repeating Jan-2021 count for every [rec year month]. 

Please advice me to sort out this issue so that it would not repeat same count .

Thanks & Regards

Narender

[v-jayw-msft · Accepted solution]

Hi @NarenderMakhija ,

I see you are using group by in sql, you may try this formula:

calculate(DISTINCTCOUNT(Stage1_BI_Filers[NO_OF_FILERS]),FILTER(ALLEXCEPT(Stage1_BI_Filers,[Year Month]), Stage1_BI_Filers[RECEIVED_DATE]<>"NUL"))

Best Regards,

Jay

[NarenderMakhija]

Hello Team,
Any one knows about this?

Thanks 

Narender