Forum Discussion

tiagolangendorf's avatar
tiagolangendorf
Regular Visitor
2 years ago
Solved

Formula dax

Olá! Preciso de ajuda com o Power BI. Tenho duas tabelas: uma chamada 'Ordem de Compra' e outra 'Pedido'. Na tabela 'Pedido', tenho as colunas 'Índice' (variando de 1 ao infinito), 'Pedido' (contendo...
  • JamesFR06's avatar
    JamesFR06
    2 years ago

    Hi @tiagolangerdof,

     

    You just made a Mix when you copy the measure

    Change this with ==> 

    Min( 'Ordem de compra'[indice] ),

     

     

lbendlin's avatar
lbendlin
Super User
2 years ago

Do you want a static assignment, or can any of this be impacted by user filters or changes in sort order?

tiagolangendorf's avatar
tiagolangendorf
Regular Visitor
2 years ago


Hello, I have filters only for zero balance, for example. I have a formula that first shows where in the queue that request is and then uses the inventory balance to deduct from the request. I use this to get orders with zero balance because those are the ones I intend to use the formula I'm looking for... So yes, there is a filter to only show items with zero balance.