Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Comments for filters

Hi Guys,   I need a measure where if my filter is selected i need my comments(Which are in Multiple line) else i need blank.   Basically if i am using Max, i am getting the top comments, i am not...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI Anonymous ,

    You can use following measure formula to achieve your requirement:

    Dynamic comment = 
IF (
    COUNTROWS (
        EXCEPT ( ALL ( T1[Region Name] ), ALLSELECTED ( T1[Region Name] ) )
    ) > 0,
    CONCATENATEX ( VALUES ( T1[Region Comments] ), [Region Comments], "," ),
    CONCATENATEX ( VALUES ( T2[Region Comments] ), [Region Comments], "," )
)

    Notice:

    1. T1 is sheet1, T2 is sheet2.

    2. Current power bi can't find out the difference between 'all selected' and 'unselected', so measure formula will recognize 'all selected' and 'unselected' as 'unselect'.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

Anonymous wrote:

HI Anonymous ,

I'm not so clear for your comment tables, can you please explain more about these?

How to Get Your Question Answered Quickly
In addition you can also try to use following measure formula if it works:

Measure =
IF (
    ISINSCOPE ( Region[Region] ),
    CONCATENATEX (
        FILTER (
            ALLSELECTED ( 'Region Comment' ),
            [Region] IN VALUES ( Region[Region] )
        ),
        [Comment Column],
        ";"
    ),
    CONCATENATEX (
        FILTER (
            ALLSELECTED ( 'Group Comment' ),
            [Region] IN VALUES ( Region[Region] )
        ),
        [Comment Column],
        ";"
    )
)

Regards,

Xiaoxin Sheng

Anonymous wrote:

HI Anonymous ,

I'm not so clear for your comment tables, can you please explain more about these?

How to Get Your Question Answered Quickly
In addition you can also try to use following measure formula if it works:

Measure =
IF (
    ISINSCOPE ( Region[Region] ),
    CONCATENATEX (
        FILTER (
            ALLSELECTED ( 'Region Comment' ),
            [Region] IN VALUES ( Region[Region] )
        ),
        [Comment Column],
        ";"
    ),
    CONCATENATEX (
        FILTER (
            ALLSELECTED ( 'Group Comment' ),
            [Region] IN VALUES ( Region[Region] )
        ),
        [Comment Column],
        ";"
    )
)

Regards,

Xiaoxin Sheng

Hi Anonymous 

Please ignore the above image.

 

I have two page, 1st page with region and their comments and 2nd page with Group comments.

 

I have region in filter in all Tab. Now if I don’t select filter I need the comments from 2nd page, Incase if I select the filter for region I need comments from page 1 with particular filter.

 

unfortunatly i dont have access to any dropbox or external mail ID.

 

Please let me know if i need to be more detailed.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

Can you please share some fake data with same data structure and copy them to your post with table format?(copy them to excel, then copy correspond worksheet cell range and paste to your post) It will help for test to coding formula.

Sample:

table1

Test Test2
123 231
123 123

table2

Test Test2
123 231
123 123

 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous 

    i have 5 region in filter, in Sheet 1.

    Sheet 1  
    Region NameRegion Comments
    Asfghrfgnhg yhethfbfghgfgyjhmghjfgdh
    Adfhrgjdfgxfgchbhhfghnfmkghjhcgxfgbfhgk
    Bfbjkvdfbv
    Bsdfvgdfbfg
    Csvdbfnbfgbh
    Dfbgghdnfhk,ylhdvgbdf
    Esdfgdjhndgbdgf

     

    In sheet 2,

    Sheet 2 
    Region Name
    Globaldsvsfvgasdmkfvkgsb f
    Globaldcakhfgvsrdfjsadhgfv

     

    I have 5 region, incase if nothing is selected i need Sheet2 global comments in one pragraph, 

    incase if some region is selected then i need sheet 1 comments for that particular region.

     

    Thanks for your support and help.

     

    Regards,

    Nagesh

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      HI Anonymous ,

      You can use following measure formula to achieve your requirement:

      Dynamic comment = 
IF (
    COUNTROWS (
        EXCEPT ( ALL ( T1[Region Name] ), ALLSELECTED ( T1[Region Name] ) )
    ) > 0,
    CONCATENATEX ( VALUES ( T1[Region Comments] ), [Region Comments], "," ),
    CONCATENATEX ( VALUES ( T2[Region Comments] ), [Region Comments], "," )
)

      Notice:

      1. T1 is sheet1, T2 is sheet2.

      2. Current power bi can't find out the difference between 'all selected' and 'unselected', so measure formula will recognize 'all selected' and 'unselected' as 'unselect'.

      Regards,

      Xiaoxin Sheng