Measure to show only STAFF customers in the table

[gbarr12345]

Hi guys,

I'm trying to write a measure that will only show the staff customers in the table without the need for a slicer or visual filter.

I have a measure that kind of works but it still shows the customers who are not staff when I want them excluded:

My current measure is below:

STAFF Customers =

CALCULATE(

    COUNTROWS( 'Dimension_Customer Table'),

    'Dimension_Customer Table'[Customer Class] IN {"Staff"}

)

Any help would be appreciated 🙂 

[Wilson_]

gbarr12345,

Add a filter to the visual/page for [STAFF Customers] > 0.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

[gbarr12345]

How would I add the filter code to my current code would you know?

STAFF Customers =

CALCULATE(

    COUNTROWS( 'Dimension_Customer Table'),

    'Dimension_Customer Table'[Customer Class] IN {"Staff"}

)

[Wilson_]

gbarr12345,

When I say add a filter to the visual/page for [STAFF Customers] > 0, I am not referring to your measure; I am referring to the filter pane on the right.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

[gbarr12345]

Oh yeah, I know I can do that but my company are looking to add this filter within the measure to make it easier for the end user.

Is it possible to add a rule within the measure without the need to alter that filter pane?

[Wilson_]

gbarr12345,

Maybe I lack imagination but I don't see how that makes it easier for the end user than you applying the filter as the report builder. In any case, I don't believe you can use a measure alone to return fewer rows - unless you add that filter condition to every other measure in the visual........ but at that point, I don't see why it would be better than adding the filter in the filter pane.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

[gbarr12345 · Accepted solution]

No problem at all.

I was just asked by my manager to try that as he wants them to just be able to see the data they're looking for straight away without having to have to use filters but maybe slicers will have to do.

Thanks for your help all the same!