Forum Discussion

Frequent Visitor

3 years ago

Solved

Calculate Count from different Table

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.

Tutorial Requests

v-jialluo-msft
3 years ago
^{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.}

3 Replies

v-jialluo-msft
Community Support
3 years ago
^{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.}
- Zaibsrule88
  Frequent Visitor
  3 years ago
  Thank you @v-jialluo-msft.
v-jialluo-msft
Community Support
3 years ago
^{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}