Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

filters

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 excl...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Fowmy's avatar
Fowmy
Super User
4 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

    • Fowmy's avatar
      Fowmy
      Super User
      4 years ago

      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

       



    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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