cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
andrmi Regular Visitor
Regular Visitor

Add calculated column from related table which accepts filters on related table

Hi,

I would like to create a calculated column (measure doesn't work since I want to use it in a slicer) where the value is a count of values in a related table. If I were to filter on the related table, the values in the calculated column should be updated. 

 

Example: 

Table A is basically a list of companies we do business with and some of their characteristics. Table B is a list of users working for these companies. Each user (row) in Table B has an assigned user type, let's say Type 1 and Type 2. I want to create a calculated column in Table A that counts the number of users in Table B for each company. This column should be used as a slicer in my report. I also want to create a slicer with user type, so if I select Type 1, the slicer with number of users should be updated such that only users with type 1 is counted. 

 

I have tried COUNTROWS(RELATEDTABLE('Table B')), but if I select Type 1 in my slicer, this still counts both Type 1 and Type 2 users. The relationship between Table A and Table B is "Both", but I have tried with "Single" as well without success. This is really easy with a measure, but the measure cannot be used as a slicer. 

 

Any suggestions?

1 REPLY 1
Community Support Team
Community Support Team

Re: Add calculated column from related table which accepts filters on related table

Hi @andrmi ,

Current power bi not support to create dynamic calculated column/table based on slicer/filter. Please use measure to instead.

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 253 members 2,546 guests
Please welcome our newest community members: