Forum Discussion
Helper IMeasure only at selected row
StockLevel =
...
...
...
// added just before 'return result'
var __statusLevering = SELECTEDVALUE(AvStockLevel[Status Levering])
var __shouldDisplay =
__statusLevering in {
"open", "in levering",
"geblokkeerd", "niet bevestigd"
}
return
// instead of returning result...
if( __shouldDisplay, result )
Helper IHi!
I have changed my measure to;
StockNiveau =
var currentArticle = if (HASONEVALUE(AvStokLevel[Artikelnr]); min(AvStokLevel[Artikelnr]);0)
var StockLevel = CALCULATE(sum(AvStock[TotalStock]); AvStock[Artikelnr.] = currentArticle)
var x =
CALCULATE(
SUM(AvStokLevel[Aantal bevestigd]);
AvStokLevel[Artikelnr] = currentArticle;
FILTER(
ALL(AvStokLevel);
AvStokLevel[Datum bevestigd]< MAX(AvStokLevel[Datum bevestigd])
)
)
var result = StockLevel - x
var __statusLevering = SELECTEDVALUE(AvStokLevel[Status levering])
var __shouldDisplay =
__statusLevering in {
"Open"; "In levering";
"Geblokkeerd"; "Niet bevestigd"
}
return
if( __shouldDisplay; result )
Only now it keeps on running again 🤔
- What does it mean "it keeps on running again"?
Best
D- AudreyWen
Oh Sorry, I mean that when i add this measure in my report (in the table) than it won't give the measure as column. It looks like it keeps on thinking what it should do
- I'm not sure if you know the difference between a measure and a calculated column... If we can't agree on the meaning of words, then I won't be able to help. Sorry.
Best
D