Forum Discussion
Solved
Get Values from one table not present in another filtered table
I have a table of facts and several tables of measures to supplement it. I need to output a list of report names that do not occur in the fact table for the selected date. I will need to...
Found solution by myself.
I have created mesure:
isMissingReport = VAR CurrentReportID = SELECTEDVALUE( report[id] ) VAR FilteredReportIDs = CALCULATETABLE ( VALUES ( fact[reportid] ) ) RETURN IF ( NOT CONTAINS ( FilteredReportIDs, fact[reportid], CurrentReportID ), "TRUE", "FALSE" )and add this measure in visuals as filter.
As result have this picture:
All filters work. And I alse create same measures for other dims (user etc.)
Found solution by myself.
I have created mesure:
isMissingReport =
VAR CurrentReportID = SELECTEDVALUE( report[id] )
VAR FilteredReportIDs =
CALCULATETABLE (
VALUES ( fact[reportid] )
)
RETURN
IF (
NOT CONTAINS ( FilteredReportIDs, fact[reportid], CurrentReportID ),
"TRUE",
"FALSE"
)and add this measure in visuals as filter.
As result have this picture:
All filters work. And I alse create same measures for other dims (user etc.)