Forum Discussion
bsas
Post Patron
Post PatronGet selected value from slicer to filter caltulate table
Hi Community! I have 2 fact tables Actual and Scenario ( weekly snapshot data for last 4 weeks) and dimention table which filter Scenario table, need to find ID from Actual table which are not pre...
You can try creating a measure like
__NewTest = VAR _vAct = VALUES ( Data[ID] ) VAR _vSc = CALCULATETABLE ( VALUES ( ScenarioData[ID] ), REMOVEFILTERS ( 'Data' ) ) VAR _vNew = EXCEPT ( _vAct, _vSc ) RETURN CALCULATE ( SUM ( Data[Amount] ), _vNew )and use that in a visual with columns from the Data table.
johnt75
Super User
Super UserYou can try creating a measure like
__NewTest =
VAR _vAct =
VALUES ( Data[ID] )
VAR _vSc =
CALCULATETABLE ( VALUES ( ScenarioData[ID] ), REMOVEFILTERS ( 'Data' ) )
VAR _vNew =
EXCEPT ( _vAct, _vSc )
RETURN
CALCULATE ( SUM ( Data[Amount] ), _vNew )
and use that in a visual with columns from the Data table.
