Shane Hutch
New Member
- Joined
- Apr 18, 2017
- Messages
- 1
Hi all,
Please can i get some assistance, I've created a Sales monitoring Widget for the sales Team using PowerBi. Is uses a card Visual With Daily Weekly , MTD , QTD YTD Figures
Using the Dax Functions if the data is unfiltered is by Branch the MTD,QTD,YTD return as Blank Values.
I Have checked for Nulls, or non Alph numeric items which there are none. As soon as I apply a filter I.E a Branch or Sales Rep the Formulea work and Display the Values :
Here are the Measures written :
Sales Revenue = sumx('Sales Fact','Sales Fact'[price]*'Sales Fact'[quantity])
Sales Daily Revenue = CALCULATE([Sales Revenue],'Date Dim'[Date]=TODAY())
Sales WTD Revenue = CALCULATE('Sales Fact'[Sales Revenue],FILTER('Date Dim','Date Dim'[Week Number]=WEEKNUM(today())&&'Date Dim'[Year]=YEAR(TODAY())))
Sales MTD Revenue = TOTALMTD('Sales Fact'[Sales Revenue],'Date Dim'[Date])
Sales QTD Revenue = TOTALQTD('Sales Fact'[Sales Revenue],'Date Dim'[Date])
Sales YTD Revenue = TOTALYTD('Sales Fact'[Sales Revenue],'Date Dim'[Date],"30-06")
Please can i get some assistance, I've created a Sales monitoring Widget for the sales Team using PowerBi. Is uses a card Visual With Daily Weekly , MTD , QTD YTD Figures
Using the Dax Functions if the data is unfiltered is by Branch the MTD,QTD,YTD return as Blank Values.
I Have checked for Nulls, or non Alph numeric items which there are none. As soon as I apply a filter I.E a Branch or Sales Rep the Formulea work and Display the Values :
Here are the Measures written :
Sales Revenue = sumx('Sales Fact','Sales Fact'[price]*'Sales Fact'[quantity])
Sales Daily Revenue = CALCULATE([Sales Revenue],'Date Dim'[Date]=TODAY())
Sales WTD Revenue = CALCULATE('Sales Fact'[Sales Revenue],FILTER('Date Dim','Date Dim'[Week Number]=WEEKNUM(today())&&'Date Dim'[Year]=YEAR(TODAY())))
Sales MTD Revenue = TOTALMTD('Sales Fact'[Sales Revenue],'Date Dim'[Date])
Sales QTD Revenue = TOTALQTD('Sales Fact'[Sales Revenue],'Date Dim'[Date])
Sales YTD Revenue = TOTALYTD('Sales Fact'[Sales Revenue],'Date Dim'[Date],"30-06")