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 ,

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