Forum Discussion
Limited Relationship
Hello everyone,
I have a model where one table is in Direct Query mode and the other is in Import
I need to add my own class to the id's which iam doing manually in excel. I have no way of knowing when a new id is added to Dim_id, for me to create a class record for it in excel. So i want to see a blank in class value when a new id is there without a class which helps me to go to my excel and add a class for it (is easy if both tables are direct query or both are import)
But when i have a model where one table is in Direct Query mode and the other is in Import, i am missing the blank value.
There is no possibility of making both the tables to either Direct Query or Import.
Is there a work around or any other solution for it? All suggestions are appreciated.
You could create a couple of measure, one to show the number of missing entries and one to show the actual entries.
Num missing classes = VAR DQIDs = VALUES ( DQ_Dim_id[id] ) VAR ImportIDs = VALUES ( class[id] ) VAR Missing = EXCEPT ( DQIDs, ImportIDs ) VAR Result = COUNTROWS ( Missing ) RETURN ResultMissing classes = VAR DQIDs = VALUES ( DQ_Dim_id[id] ) VAR ImportIDs = VALUES ( class[id] ) VAR Missing = EXCEPT ( DQIDs, ImportIDs ) VAR Result = CONCATENATEX ( Missing, DQ_Dim_id[id], UNICHAR ( 10 ) ) RETURN ResultIf you put the num missing measure in a card visual you can add it to a dashboard and set up an alert so that you get notified whenever the number goes above 0.
2 Replies
You could create a couple of measure, one to show the number of missing entries and one to show the actual entries.
Num missing classes = VAR DQIDs = VALUES ( DQ_Dim_id[id] ) VAR ImportIDs = VALUES ( class[id] ) VAR Missing = EXCEPT ( DQIDs, ImportIDs ) VAR Result = COUNTROWS ( Missing ) RETURN ResultMissing classes = VAR DQIDs = VALUES ( DQ_Dim_id[id] ) VAR ImportIDs = VALUES ( class[id] ) VAR Missing = EXCEPT ( DQIDs, ImportIDs ) VAR Result = CONCATENATEX ( Missing, DQ_Dim_id[id], UNICHAR ( 10 ) ) RETURN ResultIf you put the num missing measure in a card visual you can add it to a dashboard and set up an alert so that you get notified whenever the number goes above 0.
