Forum Discussion

powerbi2srm's avatar
powerbi2srm
Resolver II
3 years ago
Solved

Calcular datos que cumplan con dos condiciones

Hola! Os hago una breve explicación. Tengo tres tablas: una de albaranes (fact_stock_picking), una de líneas de albarán (fact_stock_move) y otra de estado de las albaranes y sus líneas (dim_picking_...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    Prueba con la siguiente medida:

    albaranes_realizado_con_lineas_otro =
VAR _S1 =
    CALCULATETABLE (
        VALUES ( 'fStock move'[stock_picking_id] ),
        FILTER ( ALL ( 'fStock move' ), 'fStock move'[picking_status] = 1 )
    )
VAR _SOthers =
    CALCULATETABLE (
        VALUES ( 'fStock move'[stock_picking_id] ),
        FILTER ( ALL ( 'fStock move' ), 'fStock move'[picking_status] <> 1 )
    )
VAR _Cross =
    INTERSECT ( _SOthers, _S1 )
VAR _Other =
    COUNTROWS ( FILTER ( 'fStock move', 'fStock move'[picking_status] <> 1 ) )
RETURN
    IF ( AND ( MAX ( 'fStock move'[stock_picking_id] ) IN _Cross, _Other = 1 ), 1 )

     

PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

Prueba con la siguiente medida:

albaranes_realizado_con_lineas_otro =
VAR _S1 =
    CALCULATETABLE (
        VALUES ( 'fStock move'[stock_picking_id] ),
        FILTER ( ALL ( 'fStock move' ), 'fStock move'[picking_status] = 1 )
    )
VAR _SOthers =
    CALCULATETABLE (
        VALUES ( 'fStock move'[stock_picking_id] ),
        FILTER ( ALL ( 'fStock move' ), 'fStock move'[picking_status] <> 1 )
    )
VAR _Cross =
    INTERSECT ( _SOthers, _S1 )
VAR _Other =
    COUNTROWS ( FILTER ( 'fStock move', 'fStock move'[picking_status] <> 1 ) )
RETURN
    IF ( AND ( MAX ( 'fStock move'[stock_picking_id] ) IN _Cross, _Other = 1 ), 1 )