Forum Discussion

NarenderMakhija's avatar
NarenderMakhija
New Member
3 years ago
Solved

Measure values are repeating in table

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

 

 

 

 

 

 

 

 

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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