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

isjoycewang's avatar
isjoycewang
Solution Supplier
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