Forum Discussion
DAX To filter data based on another measure
I am looking to filter Measure based on value Present. So in example below i am looking to average out based on only values sold .. For Example i have three rows of sales but 4 rows of allocation ,...
HotChilli
Community Champion
Community ChampionIf the allocation is always "1" then
Measure 3 = DIVIDE(SUM(Table1[Sale]), COUNTROWS(FILTER(Table1, Table1[Sale] <> BLANK())))
Allocation is not always 1 .. It based on number of days selected in date range..
- tarunsingla
Solution Sage
Measure 3 = DIVIDE(SUM(Table1[Sale]), SUMX(FILTER(Table1, Table1[Sale] <> BLANK()), Allocation))
https://docs.microsoft.com/en-us/dax/sumx-function-dax#example
