Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi every one,
Really appriciate if someone can help me here.
I need to calculate the COUNT for a user from 3 different Tables,
Ive created data model got the count from 2 tables - Im stuck at 3rd one.
The 3rd table contains only user_id with multiple dates, I need a count of ID with certain date.
Solved! Go to Solution.
Hi @Zaibsrule88 ,
What are the specific filter criteria? Please provide sample data and projected output to further troubleshoot the issue.
You can also try similar measures:
COUNT = COUNTROWS(FILTER(ALL('Table'),'Table'[Date]>DATE(2022,07,01)))
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Zaibsrule88 ,
Has your question been resolved? If yes, Mark a helpful reply for you or Mark your own reply as a solution to the post
Best Regards,
Gallen Luo
Hi @Zaibsrule88 ,
What are the specific filter criteria? Please provide sample data and projected output to further troubleshoot the issue.
You can also try similar measures:
COUNT = COUNTROWS(FILTER(ALL('Table'),'Table'[Date]>DATE(2022,07,01)))
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you @v-jialluo-msft.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |