Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have two tables "Projects" and "Issues". Both the tables have the similar field as Project ID.
If there are 10 projects present in Projects table with unique 10 Project IDs, the the Issues table may contain issues for around 5 projects which has respective issues related to it.
Now I have a calculated column in Issue tables to get some color fields which is given as formula to other rectangle shape components in reports. Those components does not works for other 5 projects which are not present in Issues tables. I need to handle it by giving some other values for not present values ? How to do this ?
Solved! Go to Solution.
You do this by specifying BLANK() for that branch of the decision tree.
Hi,
Share some data and show the expected result.
You do this by specifying BLANK() for that branch of the decision tree.
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |