topic Re: filters in Developer

filters

Anonymous — Tue, 16 Aug 2022 18:20:58 GMT

Many of these items should not be in the report but because i cannot figure out how to filter columns in a matrix. Open to adding sometype of indicator if required.

in this visual i want to exclude any item that has positive values in the column with production < 12 weeks. We should only have values where production under 12 weeks is zero or less and production is greater than 12 weeks.

A good example of the challenge is that item 00180 would not be on the report because it has some production < 12 weeks. The only ones that should be on the report are 5081796 and 5082178.

Re: filters

Fowmy — Tue, 16 Aug 2022 19:23:32 GMT

@Anonymous

Turn on the Filter Pane under View Tab and apply the filter as I have done below to show only the items here the Production < 12 Weeks <= 0

Re: filters

Anonymous — Tue, 16 Aug 2022 19:33:21 GMT

it is a matirx so the < 12 weeks and > 12 weeks are in the same column. Also Production indicator is no a numric value

Re: filters

Fowmy — Tue, 16 Aug 2022 19:46:58 GMT

@Anonymous

Create two measures

Production< 12 Weeks = SUM( Table5[Data Production< 12 Weeks]) Production> 12 Weeks = SUM( Table5[Data Production >12 Weeks])

Then insert them in the Values section of the matrix

Re: filters

Anonymous — Fri, 19 Aug 2022 07:43:37 GMT

Hi @Anonymous,

If your raw data looks like the one in below table, and you have the measure ( Measure=SUM('Table'[Value]) ) to get the value of Values field. You can create a measure as below and apply a visual-level filter on your current visual with the condition(Flag is 1) to exclude any item that has positive values in the column with production < 12 weeks...

DOH Product & Description	Production indicator	Value
00079 - SIM STAND TWIST	Productin < 12 Weeks	2810
00081 - VOLU FEED 60ML DISP	Productin < 12 Weeks	351
0009456 - SIM PREMATURE NPL AND RNG	Productin < 12 Weeks	756
00180 -VOLU FEED 60ML	Productin < 12 Weeks	1672
00336 PDLYTE GRP 1L BTL 8CT	Productin < 12 Weeks	36686
00180 -VOLU FEED 60ML	Productin > 12 Weeks	11200
00336 PDLYTE GRP 1L BTL 8CT	Productin > 12 Weeks	40938
5082178-SIM ORGANIC ES 1.45LB	Productin > 12 Weeks	25
5081776-SIM SENS 1.41LB/22/5OZ PWD 6CT	Productin > 12 Weeks	55
5081777-SIM SENS 1.41LB/22/5OZ PWD 6CT	Productin < 12 Weeks	0
5081777-SIM SENS 1.41LB/22/5OZ PWD 6CT	Productin > 12 Weeks	12

Flag = VAR _selpdesc = SELECTEDVALUE ( 'Table'[DOH Product & Description] ) VAR _selpindicator = SELECTEDVALUE ( 'Table'[Production indicator] ) VAR _pdesc = CALCULATE ( MAX ( 'Table'[DOH Product & Description] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[DOH Product & Description] = _selpdesc && 'Table'[Production indicator] = "Productin < 12 Weeks" && [Measure] > 0 ) ) RETURN IF ( _selpdesc = _pdesc, 0, 1 )

If the above one can't help you, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards