Forum Discussion
Amrselim1989
Helper II
Helper IICalculate filter OR
Item Last Cost = calculate(AVERAGE( Products[last_cost] ), FILTER(Bi_Balance_All,not(ISBLANK([Units at Stock]))) || FILTER(Bi_Basket_all,not(ISBLANK([Basket Uints])))) what's wrong here?! w...
ValtteriN
Community Champion
Community ChampionHi Amrselim1989 ,
Try this kind of structure:
Measure =
calculate(AVERAGE( 'Table'[Value] ),
FILTER('Table (2)',not(ISBLANK([Units at Stock]) || not(ISBLANK([Basket Uints])))))
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Amrselim1989Helper II
Helper IIno i can't the Basket Uints is coming from another table not table 2
calculate(AVERAGE( 'Table'[Value] ),
FILTER('Table (2)',not(ISBLANK([Units at Stock]) || "here must choose another table (not table 2)"not(ISBLANK([Basket Uints])))))