Forum Discussion
Relationship between column and measures
Hello
How r u all
thats first question to me here and i hope you help me 🙏
Now i have two tables as below :
First Table:
Second Table:
As per second table i created three measures to calculate screened, detected and advised cases
now i need to create relationship between these two tables to merge screened, detected and advised cases.
I hope I was able to make you understand the question correctly
Thank you so much.
2 Replies
- Greg_Deckler
Community Champion
Kamaladel91 In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
- Kamaladel91New Member
Thank you so much for your help but i can not to create the relations also
can i upload the file here and you help me ?!
the attached file