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.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
241 | |
49 | |
49 | |
44 | |
42 |
User | Count |
---|---|
293 | |
211 | |
82 | |
76 | |
73 |