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 ea...

Need Help

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

Forum Discussion

Measure values are repeating in table

Related content

Bottom 10 considering repeated value.

Measure Calculates Correctly but Repeats Across Every Single TransactionID

Paginated Report headers not repeating

Measure returning incorrect value

Cumulative Sum without repeat value