Forum Discussion
Solved
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 k...
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.
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
Result
Missing 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
Result
If 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.
