Forum Discussion
SJ545
3 years agoFrequent Visitor
Creating measures in a Power BI Report which uses SSAS model
I have two tables in a Power BI report which has SSAS model live connection as a data source.
GlobalProductDesc GlobalCode
123-ABC 123
452-KJK 452
979-TYG 979
GlobalProductDesc LocalCode
123-ABC 123
123-ABC 123
123-ABC 321
979-TYG 876
979-TYG 979
I want to create a visual so that when I filter 123-ABC or 979-TYG from table 1 it shows only those values in table 2 where GlobalCode <> LocalCode.
I tried creating a measure.
= CALCULATE(DISTINCTCOUNT(Sales[GlobalCode),FILTER(Sales,Sales[GlobalCode]<>Sales[LocalCode]))
Here sales is my Fact table and the modeling is something like below
Table1 ---------------->Sales<-----------------Table2
But this measure takes a lot of time to load in any viual and is not working for me
No RepliesBe the first to reply