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...
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,....
Hi Anonymous ,
If you have 2 dimension tables,it depends on the relationships between the 3 tables.
Could you share your .pbix file for test?
Remember to remove the confidential information.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!