Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank 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,....

 

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

You need to specify columns rather than tables. For example,

'DBO DIMProduct'[ProductName] IN VALUES ( 'OutputServices'[ProductName] )
    || 'DBO DIMProduct'[ProductName] IN VALUES ( 'Realtime'[ProductName] )