Forum Discussion
Filter and Measure Combo | Help
I created a measure called [Variance] which is works just fine. It gives me the change in value from today compared to the previous day. I want to apply a filter somehow that will only add-up of all the negative values only. How can I acheive this?
Anonymous , Try measures like
This Day =
var _day = if(isfiltered('Date') , Max('Date'[Date]), Today())
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]= _day))
Last Day =
var _day = if(isfiltered('Date') , Max('Date'[Date]), Today())
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]=_day-1))Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
2 Replies
Anonymous , Try measures like
This Day =
var _day = if(isfiltered('Date') , Max('Date'[Date]), Today())
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]= _day))
Last Day =
var _day = if(isfiltered('Date') , Max('Date'[Date]), Today())
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date]=_day-1))Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9Hi,
This pattern should work
Measure = SUMX(calculatetable(VALUES(Products[Product Name]),[your measure]<0),[your measure])
Drag this to a card visual.
