cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Zaibsrule88
Frequent Visitor

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.

 

1 ACCEPTED SOLUTION
v-jialluo-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
v-jialluo-msft
Community Support
Community Support

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

v-jialluo-msft
Community Support
Community Support

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.

 

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors