Forum Discussion
Getting Calculated value to appear in row
Hi Monkey76,
in order to help, we need to know:
1 - the DAX code of the measures [1 - Sales] and [2 - Proceeds On Dev Property Sales]
2 - the columns grouped in the visual (table and column names)
3 - the Data Model, seeing the tables and their relationships
Best Regards
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
- 1 - Sales =CALCULATE (SUM ( 'Monthly data'[Period Amount] ),KEEPFILTERS ('Monthly data'[Simple Category]= "Sales" ))2 - Proceeds On Dev Property Sales = CALCULATE(SUM('Monthly data'[Period Amount]),'Monthly data'[Simple Category]= "Proceeds On Dev Property Sales")8 - Cost of Goods Sold = [1 - Sales]+[2 - Proceeds On Dev Property Sales]
Super UserHi Monkey76,
in order to help, we need to know:
1 - the DAX code of the measures [1 - Sales] and [2 - Proceeds On Dev Property Sales]
2 - the columns grouped in the visual (table and column names)
3 - the Data Model, seeing the tables and their relationships
Best Regards
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI