How to show all the values based on If condition in power bi desktop

[Charu]

Dear Communtiy,

I'm trying to show all the values which satisfies the condition,but I could only see single value.

Please help me with the DAX formula.

Below is the formula I have tried but it's showing all the values not working based on condition

Measure = 

VAR NOTETXT = IF('table'[Variance %] > 0,CONCATENATEX(('table'),'table'[Category],"AND"))

VAR pretext = " Following Category ' "

VAR postcat = " 'achieved target"

RETURN pretext & NOTETXT & postcat

Below is returning single value

_vm target =

VAR NOTETXT = IF('table'[Variance %] > 0,'table'[Category])

VAR pretext = " Following Category ' "

VAR postcat = " 'achieved target"

RETURN pretext & NOTETXT & postcat

Below are the Sample data

Variance%  category  

-6.5%         CategoryA

-5.3%         CategoryB

9.3%          CategoryC

7.3%          CategoryD

Expected result is  : Following Category ' CategoryC AND CategoryD' achieved  target

[v-eachen-msft · Accepted solution]

Hi @Charu ,

Your table filter need to be configured as "'Table'[Variance%]>0" like the following measure.

Measure =
VAR NOTETXT =
    CONCATENATEX (
        FILTER ( 'Table', 'Table'[Variance%] > 0 ),
        'table'[Category],
        " AND "
    )
VAR pretext = " Following Category ' "
VAR postcat = " 'achieved target"
RETURN
    pretext & NOTETXT & postcat

Here is the result.

[Charu]

Hi @v-eachen-msft,

Thanks a lot your solution worked well.Thanks once again for this timely help 🙂

[Greg_Deckler]

Tough to tell what is going on, sample data and expected result would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Charu]

Hi @Greg_Deckler 

I did edit my post with sample data and the expected result.Hope this make sense.Please help me achieve the expected result.