cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

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.

Regards,
Nagesh

1 ACCEPTED SOLUTION
Community Support

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,
)
```

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
5 REPLIES 5
Community Support

HI @Anonymous ,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Hi @v-shex-msft ,

@v-shex-msft wrote:

HI @Anonymous ,

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 ,

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

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.

Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

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

Community Support

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,
)
```

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.