Forum Discussion

Helper I

6 years ago

Solved

Combine Measures

Hello, I am trying to combine 2 measures that both work individually but I can't get them to work when combined. Please help. The end result should only count the projects that matches the bo...

Need Help

amitchandak
6 years ago
chrismcdonald , With description, I am not clear on missing measure.

The table you want to show, all sub project completed

countx(filter(summarize(Table,table[Project ID],"_1",count(Table[Sub Project]), "_2",countx(filter(Table,not(isblank(table[Install Actual]))),Table[Install Actual])),[_1] =[_2]),table[Project ID])

If you want to work with the week. Please Use date dimension and Week rank like this

This Week = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))

Refer my file

https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0

amitchandak

Super User

6 years ago

chrismcdonald , With description, I am not clear on missing measure.

The table you want to show, all sub project completed

countx(filter(summarize(Table,table[Project ID],"_1",count(Table[Sub Project]), "_2",countx(filter(Table,not(isblank(table[Install Actual]))),Table[Install Actual])),[_1] =[_2]),table[Project ID])

If you want to work with the week. Please Use date dimension and Week rank like this

This Week = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))

Refer my file

https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0