This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hi Community,
I am having difficulties in dax calculation. I hope you guys will help me, maybe it is very simple for some of you. Below is the scenario.
I have 3 tables, date table and two tables with project ID. there is relationship in date table and project B table, and table A has master list of projects that is related with Table B using project id.
I want to get list of missing projects name from table B when comparing to master project list of table A. Now, I want to get a list of projects id based on date filtered in date slicer of date table where table B project doesn't appear in table A Project. I want to use DAX measure or column for this solution.
Thanks for the help.
Jag
Solved! Go to Solution.
@JJha75 , Use this measure along with Project from Table A in a visual
countrows(except(values(Table1[Project]), distinct(Table2[project]) ) )
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 31 | |
| 23 | |
| 23 | |
| 19 | |
| 16 |
| User | Count |
|---|---|
| 63 | |
| 36 | |
| 28 | |
| 23 | |
| 22 |