Help on Treatas DAX Code

[abhiram342]

Hi All,

I want to create measure for below scenario but not working as expected. Can someone please assist?

Scenario:

I want to get distinct Products with either no internet sales or Offline sales

EX:

In Internet sales: 2,4 ( productID)

In Offline Sales :2,3 (ProductID)

Final Measure: 2,3,4 ( Unique product from Internet and Offline Sales

DimProduct:

ProductId	ProductName
1	Bike
2	Car
3	Bi-Cycles

FactInternetSales

ProductId	SalesAmount
1	10
2	0
3	50
4	0

FactOfflineSales

ProductId	SalesAmount
1	10
2	0
3	0
4	10

Thanks,

Abhiram

[Jihwan_Kim]

Hi, @abhiram342 

Please correct me if I wrongly understood your question.

I assume you want to create a new table.

please try the below for creating a new table.

new table =

DISTINCT (

UNION (

SUMMARIZE (

FILTER ( InternetSales, InternetSales[SalesAmount] = 0 ),

InternetSales[ProductId]

),

SUMMARIZE (

FILTER ( OfflineSales, OfflineSales[SalesAmount] = 0 ),

OfflineSales[ProductId]

)

)

)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[amitchandak]

@abhiram342 , Create a measure like

new measure =Sum(FactInternetSales[SalesAmount]) + Sum(FactOfflineSales[SalesAmount])

Then create this measure 

check measure =
calculate( if( isblank([new measure]),1,blank()))

or

check measure =
countx(values(DimProduct[ProductId] ) if( isblank([new measure]),[ProductId],blank()))