Forum Discussion
Merge and expand in direct query
Hey BeaBF ,
I tried creating a relation between the table VIEW_RFIS( (T1) which is my fact table and Workflow Type Status (T2) where the common columns are NotificationWorkflowStatusId from T1 and Status Id from T2.
for your reference. here is the T2 table
| WorkflowTypeId | StatusId | StatusName | WorkflowTypeName |
| 2 | 10 | Accepted | Workflow de notificaciones |
| 2 | 11 | Rejected | Workflow de notificaciones |
| 2 | 12 | Cancelled | Workflow de notificaciones |
| 2 | 15 | Issued - Pending Construction Review | Workflow de notificaciones |
| 2 | 16 | Issued - Pending Quality Review | Workflow de notificaciones |
| 2 | 17 | Accepted Contractor | Workflow de notificaciones |
| 2 | 21 | Accepted Contractor | Workflow de notificaciones |
| 2 | 22 | Accepted Contractor and PID | Workflow de notificaciones |
| 2 | 24 | Suspended | Workflow de notificaciones |
Now in T1, I wanted a column named Notification Status Name where if the NotificationWorkflowStatusId from T1 matches the Status Id, I wanted Status Name.
Else for nulls I wanted to remain as null.
After this, I have a column named NotificationStatus in the T1. Now, I wanted another column named NotificationStatusTemp in T1 where I wanted to apply a condition like below
If Notification Status (T1) = "Issued" then it should take the value from the Notification Status Name (FYi, Previously created column) else it should take the value that is in the Notification Status.
Based on this, I should have a column waiting Execution Result based on the below formula:
=if [NotificationStatus] = "Accepted" and [ExecutionStatus] = "Not started" then "Yes" else "No"
which I will use to create another column as shown in below snip
Let me know if you can understand what I was trying to have.
Other Case:
I tried creating a relation between t1 and t2 using the common columns with *Id but when I execute the following dax it is not working and even it is not popping up the LOOKUPVALUE function.
The first icon on the left (a bar chart with a funnel) likely signifies options for filtering or setting filters at the visual level. This symbol usually suggests that you can apply specific filters to limit the data shown in the slicer or connected visuals.
The second icon on the right (a circle with a diagonal line) generally provides an option to clear or reset filters. Clicking this icon would remove any active filters applied through the slicer.
When you select the slicer without applying a filter, these icons may appear to give you quick access to filter options or to clear filters directly from the visual interface. They allow for easy management of filters within your data model or report.
BBF
Hey BeaBF ,
That's a lot of data which I can not share due to its confidentiality.
But, here is a news. I was able to create some new columns on the table using DAX and considering the values on the T2 as they are just 9.
But, I got to see these symbols when I select the slicer visual. (Select means just the shape not filtering). May I know what this is.Hey BeaBF ,
I was able to create some measures and columns using DAX. But without using the T2 table. As the values are just 9, I manually used them in the DAX in an if clause.
But, I don't know when these discontinuities started appearing between most of the tables
Please let me know if you have idea