Can I know the syntax to connect from facttable , by using dimension table name in measure?,

[AtchayaP]

This is my fact table.

Name table

name	age	id
male	11	1
female	13	2
male	11	1
female	13	2
male	11	1
female	13	2
male	56	1

This is my dimension table:

Type table

type	Type id
male	1
female	2

Actually, I want to know number of male in one card visual and no of female in one card visual .So Can I know DAX measure for this. I have tried a lot.

For example

.

[parry2k]

@AtchayaP Yes, you can surely use that, nothing wrong with it. 

Do subscribe to my YouTube channel, you will find interesting videos on Power BI.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[AtchayaP]

thank you @parry2k 

[parry2k · Accepted solution]

@AtchayaP create a relationship using the type id column in both the tables and it will create one to many relationship, one on dimensions ide and many on fact side, add following measures, and then uses these measures in the card visual

Total Count = COUNTROWS ( FactTable )

Male Count = CALCULATE ( [Total Count], DimTable[Type] = "Male" )

Female Count = CALCULATE ( [Total Count], DimTable[Type] = "Female" )

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[AtchayaP]

Thank you @parry2k  

Male Count = CALCULATE ( [Total Count], DimTable[Typeid] = 2 ) Can I use this method. I am getting same visual. But Could you suggest? which is appropriate meaaure to use?