Trying to calculate total no. of sub-products from fact table.

[kushalt1996]

Hello,

I have Table A (dim table) = This stores product name + sub-product name

I have Table B (fact table) = It has product name column. 

Req - To have total no. of sub products from table B. 

Therefore I created Table C (by grouping the first Table A to get the count of sub-products for each product).

After this I merged Table C with Table B to get the sub-product count for each Product on Table B.

But the sub-product count value was duplicating after merge as I had many entries for Product Name in column.

Now when I am creating a measure to calculate Total no. of sub-product. It also calculates the repeated sub-product count values for each product giving larger values. 

Suggest me some solution for this.

Any formula to sum this column values by not repeating sub-product count value for each product OR Do I need to change the merge operation with something else..

I have attached a snip. wrong values computed

[kushalt1996]

We can count from Table A, but I wanted to do it from Table -B.

As Table B I have assumed it to be my fact.

[Syk]

Try this

Total Sub-Products = DISTINCTCOUNT('Table A'[Sub-Product])