Forum Discussion
Calculated column countrows in another table
Is there a way to create a calclulated column that will get a count of records from another table but keeping the report filters? I have two tables Employee table with an employee id and a test tab...
That does give me the count but it is not applying the filters.
For example, I do not want to count the test number 123 for the employees.
I do not want to put the filter in the formula, I would like to use the page level and slicers already applied.
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