Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I am struggling and starting to think there isnt a straight forward way to filter this table the way i need.I want to display and count the rows left after I filter out rows that has"VehicleStockStatusCode" = 23 AND "TotalBookValue" = 0combinded on the same rowcontext.
I tried below but that filters them seperatly, not as combind row
Vehicle Stock (Filtered) =
( FactVehicleStock[TotalBookValue] <> 0 && FactVehicleStock[VehicleStockStatusCode_KEY] <> 60 ) //60 = 23
Result should be 18
Go to Solution.
You could try
Vehicle stock ( filtered ) =
VAR FilteredRows = CALCULATETABLE(
VALUES( 'FactVehicleStock'[VehicleNumber] ),
FactVehicleStock[TotalBookValue] = 0 && FactVehicleStock[VehicleStatusCode] = 23
EXCEPT( VALUES('FactVehicleStock'[VehicleNumber]), FilteredRows)
View solution in original post
Thnx johnt75 it worked as expectet 👍
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.