Forum Discussion
Create Measure from Fact Table
I have a Fact table as below and the requirement there is SalesTarget for few ProductdID, OpportunityRecordTypeID and StageID FactTable: SalesTarget for few Product, OpportunityRecordType and...
Anonymous Can you provide some sample data in a table form which is not image
Hey smpa01 , adding 20 rows of data.
OpportunityID OpportunityRecordTypeID OwnerRoleID ProductID StageID TypeID ForecastCategoryID AccountID CategoryID LostReasonID
1 1 4 1 5 8 7 1 1 1
1 1 7 1 5 8 7 1 1 1
1 1 7 1 14 8 7 1 1 1
1 1 7 1 16 8 7 1 1 1
1 1 7 1 2 8 8 1 1 1
1 1 4 1 16 8 8 1 1 1
1 1 7 1 16 8 8 1 1 1
1 1 7 1 16 9 8 1 1 1
1 1 7 1 16 3 7 1 1 1
1 1 7 1 21 3 7 1 1 1
1 1 7 1 2 3 8 1 1 1
1 1 7 1 16 3 8 1 1 1
1 1 7 1 22 4 5 1 1 1
1 1 7 1 3 4 7 1 1 1
1 1 7 1 4 4 7 1 1 1
1 1 7 1 5 4 7 1 1 1
1 1 8 1 7 5 2 1 1 1
1 1 4 1 6 5 4 1 1 1
1 1 8 1 6 5 4 1 1 1
1 1 8 1 8 5 5 1 1 1Thank you smpa01 and AlexisOlson for your time on this, I am working on implementing this solution you mentioned and evaluate the outcome.
can i ask one more query, Is there a way to assign values to Switch DAX using Dimension tables. like
SWITCH(TRUE(),'DBO DIMProduct'[ProductName] IN {'OutputServices','Realtime'} && 'DBO DIMOpportunityRecordType'[OpportunityName] = "New Client", 1234,....You need to specify columns rather than tables. For example,
'DBO DIMProduct'[ProductName] IN VALUES ( 'OutputServices'[ProductName] ) || 'DBO DIMProduct'[ProductName] IN VALUES ( 'Realtime'[ProductName] )
