Forum Discussion

jja's avatar
jja
Helper III
4 years ago
Solved

Filter visual based on slicer selection

Hi I have this schema: I have a slicer Type that is a column from Components table When selecting one of the values in this slicer i want to calculate and filter(in Donut chart visual) how m...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, jja 

     

    You can create a measure and use it in visual.

    Like this:

    Measure = COUNTX(filter(ALL(projects),[projectID] in DISTINCT(components[projectID])),[CustomerID])
//COUNTX(filter(ALL(projects),[projectID] in DISTINCT(components[projectID])),[projectID])

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

    Best Regards,
    Community Support Team _ Janey

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, jja 

 

You can create a measure and use it in visual.

Like this:

Measure = COUNTX(filter(ALL(projects),[projectID] in DISTINCT(components[projectID])),[CustomerID])
//COUNTX(filter(ALL(projects),[projectID] in DISTINCT(components[projectID])),[projectID])

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey