Forum Discussion
coolshib
Helper III
Helper IIIDax Measure with related Table
Hello Everyone, I am looking for a dax measure function based on the following logic. I have three tables, Table No.1 Category Online Price Offline Price Laptop ...
coolshibHelper III
Helper IIIThank you so much for your reply venug20.
Actually i am looking for dax measure which would return the value in a single column.
Also i dont want to add or delete any column from Table No.3 as mentioned above. The format will remain the same. In your solution you have added the category column in the dataset which i don't want.
Best Regards
Shib
Actually i am looking for dax measure which would return the value in a single column.
Also i dont want to add or delete any column from Table No.3 as mentioned above. The format will remain the same. In your solution you have added the category column in the dataset which i don't want.
Best Regards
Shib
venug20
Resolver I
Resolver I
I am trying to display same column calculation field (Online, offline). till not achieve..
you can try inthe mean while, i will provide dax formula which i has got upto till now....
Online Sales = CALCULATE(SUM('Product'[Sales.Quantity]) * SUM('Product-Price'[Online Price]), FILTER('Product', 'Product'[Category] = RELATED('Product-Price'[Category]) && 'Product'[Sales.Mode] = "Online"))
Offline Sales = CALCULATE(SUM('Product'[Sales.Quantity]) * SUM('Product-Price'[Offline Price]), FILTER('Product', 'Product'[Category] = RELATED('Product-Price'[Category]) && 'Product'[Sales.Mode] = "Offline"))