Forum Discussion

kylifeofpy's avatar
kylifeofpy
Frequent Visitor
2 years ago
Solved

Measure to filter Value counts for Visuals

Hi PowerBI Community,   Running into a problem that I’m unsure if it can be solved with a measure or is it required to have an added column, which won’t work for me since I’m using Direct Query mod...
Need Help
  • isjoycewang's avatar
    isjoycewang
    2 years ago

    Hi kylifeofpy,

     

    Please try below measure and apply it to your pie chart or column chart.

    Measure = 
COUNTX( 
    FILTER(IdentificationBadge, [Filter Measure]=1), IdentificationBadge[ID])

     

     

    Best Regards,

    Joyce

kylifeofpy's avatar
kylifeofpy
Frequent Visitor
2 years ago

Hi isjoycewang This is great! I love how it's more consolidated than applying a separate countrows DAX query, which was also provided to me as a potential solution from the Stack Overflow community. Apparently the answer was right in front of me the whole time and I'm astonished that it can be used on visuals, so thank you very much for the streamlined answer and your assistance.

isjoycewang's avatar
isjoycewang
Solution Supplier
2 years ago

Glad to help!

You already have a complete filter condition wrote in the [Filter Measure] so I think we can take advantage of this to have a easier formula 🙂