Result of a COUNT, used in another table

[petrutjim]

Hi guys,

I have 2 tables (table A and Table B) which are in a many to many realationship, trought another table (lets name it Table X).

If I join the tables, I would get the information in Table C.

Then in the dashboard, I can obtain the info from "PowerBI Table in Dashboard", by dragging column A from Table A and Column A from table B, and applying a COUNT on it. This is fine.

What I want to achieve and cannot is the last table, in which I want to keep the "Count TableC.ColumnB" and assign each fixed value to Column A.

I could use a merge, then create e new table with a group by and count, and then merge them toghether but for sure there is a solution using DAX.

Thank you in advance!

[PaulOlding]

This measure will give you your expected output.  It has the IF function in the result to check if the combination of TableA.ColumnA and TableB.ColumnA exists in Column C.

Count TableC.ColumnB =

VAR _AllCount =

CALCULATE(

COUNTROWS('Table C'),

REMOVEFILTERS('Table B'[Column A])

)

VAR _RawCount = COUNTROWS('Table C')

VAR _Result = IF(ISBLANK(_RawCount), BLANK(), _AllCount)

RETURN

_Result