Forum Discussion

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Help on Treatas DAX Code

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...
DAX
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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()))