Forum Discussion
Calculated column countrows in another table
Calculated column works with row context.
If you would like to tweek your results you have to use CALCULATE.
What about get all data (countrows) into calculated column and then work with measures and visualizations to get your goal? You can exlude every thing you want.
It's a bit hard to understand your scenario without seeing any sample data/results.
Regards
I need a calculated column. I am able to get a count by using RELATED but that does not include the slicers and report filters. I need to include the report filters.
For example:
Contact table
Contact ID |
|
111 |
|
222 |
|
333 |
|
Evaluation Table
Test Number | Test Category | Contact ID |
1 | Category 1 | 111 |
2 | Category 2 | 111 |
3 | Category 3 | 111 |
1 | Category 1 | 222 |
1 | Category 1 | 222 |
2 | Category 2 | 333 |
2 | Category 2 | 333 |
1 | Category 1 | 333 |
my report filters out counting category 2 test so here are my expected results
Contact ID | count of tests (calculated column-needs to be created) |
111 | 2 |
222 | 2 |
333 | 1 |
using COUNTROWS(RELATEDTABLE(Evaluation)) in the contact table the page level filters are not applied, so this is what that calculated column returns