Search code examples
powerbidax

How to apply a filter to new tabs

enter image description here

Hi everybody, in case I would like to apply a measure in these new tabs  in order that only where a filter is selected it should show values while if not the symbol to visualize the symbol is --, what should text in measure? I specify that % values that you see in the pic are actegorical

Thanks

Solution

  • You can use HASONEVALUE('table'[column]) to determine there is only one value (ie filtered to one value).

    Col B % = 
  IF(
    HASONEVALUE('YourTable'[Country]),
    MIN('YourTable'[Col B]),
    "--"
  )