Forum Discussion
Filter matrix for negative values
Hi DCELL ,
You can try the following formula:
Filter_Consolidate = VAR temp_table = CALCULATETABLE ( FILTER ( ADDCOLUMNS ( SUMMARIZE ( DemandSupply, DemandSupply[Part], Cal[Fiscal Year], Cal[rDate] ), "_Consolidated", [Consolidated Planning Data] ), [_Consolidated] < 0 ), ALL ( Cal ), ALLEXCEPT ( DemandSupply, DemandSupply[Part] ) ) RETURN COUNTROWS ( temp_table )Has you can see below is only presenting one row:
Hi DCELL ,
To understand you want to have the lines that have a negative value in any column is that it?
Because looking at the values you are presenting how do I know that the DEF should be present is because those two values are negative?
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
MFelix,
In simple terms, I need Power BI to "Show me parts that will have a projected quantity on hand less than zero at any point in time."
I edited my original post and pasted a link at the end.
Thanks!!
Hi DCELL ,
You can try the following formula:
Filter_Consolidate = VAR temp_table = CALCULATETABLE ( FILTER ( ADDCOLUMNS ( SUMMARIZE ( DemandSupply, DemandSupply[Part], Cal[Fiscal Year], Cal[rDate] ), "_Consolidated", [Consolidated Planning Data] ), [_Consolidated] < 0 ), ALL ( Cal ), ALLEXCEPT ( DemandSupply, DemandSupply[Part] ) ) RETURN COUNTROWS ( temp_table )Has you can see below is only presenting one row: