Forum Discussion

SJ545's avatar
SJ545
Frequent Visitor
3 years ago

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