Forum Discussion
Calculate 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...
Hi,
Share data in a format that can be pasted in an MS Excel file, explain the question and show the expected result.
Hi,
In the Query Editor, append the 2 tables (call that table Data). Create a single column table with all unique Names (call this table Names). Create a many to one relationship from the Data table and Product table to the Names table. To your visual, drag Name from the Names table. Write this measure
Measure = if(sum(Data[Balance])=0,blank(),sum(Product[Price]))
Hope this helps.
i can't actullay do that, it's ver complicated cube with alot of relationships, i just tried to simplfy as mush as i can, but iused another measure
VAR not_in_Scope = not(ISINSCOPE(Products[Item]))Var Check_ = AND(ISBLANK(count(Bi_Balance_All[ProductID])),ISBLANK(count(Bi_Basket_all[MODEL_ID])))returnif(Check_=TRUE() || not_in_Scope = True() ,blank(),AVERAGE(Products[last_cost]))
------------------------------------------------------------------------VAR balance = CALCULATE(AVERAGE(Products[last_cost]), FILTER(Bi_Balance_All,not(isblank([Units at Stock]))))VAR basket = CALCULATE(AVERAGE(Products[last_cost]), FILTER(Bi_Basket_all,not(isblank([Basket Uints]))))returnif( isblank(balance) && isblank(basket),blank(),AVERAGE(Products[last_cost])),they both worked, i juts can't imagine that i can't use or with calculate and filter?!!!!
