Comments for filters

[Anonymous]

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 gettingthe complect comments

Attached is the screenshot.

Thanks in advance for your support

Regards,
Nagesh

[v-shex-msft]

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]

Hi @v-shex-msft ,

---

@v-shex-msft 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

---

---

@v-shex-msft 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 @v-shex-msft 

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.

[v-shex-msft]

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]

---

---

Hi @v-shex-msft 

i have 5 region in filter, in Sheet 1.

Sheet 1
Region Name	Region Comments
A	sfghrfgnhg yhethfbfghgfgyjhmghjfgdh
A	dfhrgjdfgxfgchbhhfghnfmkghjhcgxfgbfhgk
B	fbjkvdfbv
B	sdfvgdfbfg
C	svdbfnbfgbh
D	fbgghdnfhk,ylhdvgbdf
E	sdfgdjhndgbdgf

In sheet 2,

Sheet 2
Region Name
Global	dsvsfvgasdmkfvkgsb f
Global	dcakhfgvsrdfjsadhgfv

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

[v-shex-msft · Accepted solution]

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