Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Solved! Go to 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
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
Hello Team,
Any one knows about this?
Thanks
Narender
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |