Forum Discussion

JS's avatar
JS
Helper II
4 years ago
Solved

Partial filter with concatenate value

Hello all gurus!    Seeking some advise if this is something possible.    Say i have a simple fact table below:    Client Team Revenue Client A Team A 500 Client A Team B 100 ...
Need Help
Tips and Tricks
  • isabella's avatar
    isabella
    4 years ago

    Hi JS 

     

    I did a local test，my approach is to create measure，

    One measure is to sum the revenue，the other one is to concatenate the team name

    Measure = CALCULATE(SUM('Table (2)'[Revenue]),FILTER(ALL('Table (2)'),[Client] = MAX('Table (2)'[Client])))
    Measure 2 = calculate(CONCATENATEX(VALUES('Table (2)'[Team]),[Team],"&"),FILTER(ALL('Table (2)'),[Client] = MAX('Table (2)'[Client])))

     

     

     

     

     

     

    Best Regards,

    Community Support Team _Isabella

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

JS ,

Try like

Team Involved = calculate( CONCATENATEX(VALUES(Sales[Team]), Sales[Team], " & "), removefilters(Sales[Team]) )

JS's avatar
JS
Helper II
4 years ago

Hello amitchandak 

Thanks for the prompt response! It did partially solved the problem, however i had missed out one important element. I just edited my post above. 

 

I filtered the chart to only show 2 teams or more in a specific client. However with that filter count, when i just select Team A on my silcer, the chart is registering as ONE team count, and the chart will not show what is required. 

But thanks again!