Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional Title using Quick measure calculation 'Concatenated list of values'

Hello all,   My goal is to use a Card-Visualization to list all selected filters from a slicer. For this I used a quick measure and selected 'Concatenated list of values'. While this gets me the re...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi Anonymous ,

     

    I got this working by creating a measure as shown below:

     

    new Check =
    var total = CALCULATE(COUNT(ColorSample[color]), ALL(ColorSample[color]))
    RETURN
    IF(HASONEVALUE(ColorSample[color]), SELECTEDVALUE(ColorSample[color]), IF(COUNT(ColorSample[color]) > 1 && COUNT(ColorSample[color]) < total, CONCATENATEX(VALUES(ColorSample[color]), ColorSample[color], UNICHAR(10)) , "All Selected"))
     
    NOTE: "ColorSample[color]" is my color columns with different color values. Replace this with your column.
     
    Move this measure to your card visual. You get as follows:
     
    1. when selected few values from slicer:
    2. When everything is selected:
     
    Hope this works for you.
    If it works please mark this as a solution 🙂
     
    Thanks,
    Pragati

     

     

  • Pragati11's avatar
    Pragati11
    6 years ago

    HI Anonymous 

     

    Just modify the measure to the following:

     

    new Check = var total = CALCULATE(COUNT(ColorSample[color]), ALL(ColorSample[color])) RETURN IF(HASONEVALUE(ColorSample[color]), SELECTEDVALUE(ColorSample[color]), IF(COUNT(ColorSample[color]) > 1 && COUNT(ColorSample[color]) < total, CONCATENATEX(VALUES(ColorSample[color]), CONCATENATE(ColorSample[color], ","), UNICHAR(10)) , "All Selected"))
     
    This will work and give you desired output.
     
    I generally use https://docs.microsoft.com/en-us/dax/ to refer to DAX functions in Power BI.
     
    Give Kudos and accept as a solution! 🙂
     
    Thanks,
    Pragati
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

I got this working by creating a measure as shown below:

 

new Check =
var total = CALCULATE(COUNT(ColorSample[color]), ALL(ColorSample[color]))
RETURN
IF(HASONEVALUE(ColorSample[color]), SELECTEDVALUE(ColorSample[color]), IF(COUNT(ColorSample[color]) > 1 && COUNT(ColorSample[color]) < total, CONCATENATEX(VALUES(ColorSample[color]), ColorSample[color], UNICHAR(10)) , "All Selected"))
 
NOTE: "ColorSample[color]" is my color columns with different color values. Replace this with your column.
 
Move this measure to your card visual. You get as follows:
 
1. when selected few values from slicer:
2. When everything is selected:
 
Hope this works for you.
If it works please mark this as a solution 🙂
 
Thanks,
Pragati

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you very much for your help, Pragati11  !

I copied the measure and it works great. Would the measure need to be change lot, if I also would like to have have a comma (or &) after each selected filter, except the last?

 

Yellow,

Orange,

Red

 

By the way, would you recommend any websites or other resources for learning about Power BI or DAX?

 

Thanks again.

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    HI Anonymous 

     

    Just modify the measure to the following:

     

    new Check = var total = CALCULATE(COUNT(ColorSample[color]), ALL(ColorSample[color])) RETURN IF(HASONEVALUE(ColorSample[color]), SELECTEDVALUE(ColorSample[color]), IF(COUNT(ColorSample[color]) > 1 && COUNT(ColorSample[color]) < total, CONCATENATEX(VALUES(ColorSample[color]), CONCATENATE(ColorSample[color], ","), UNICHAR(10)) , "All Selected"))
     
    This will work and give you desired output.
     
    I generally use https://docs.microsoft.com/en-us/dax/ to refer to DAX functions in Power BI.
     
    Give Kudos and accept as a solution! 🙂
     
    Thanks,
    Pragati