Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
curtismob
Helper IV
Helper IV

Create a slicer using a measure

Hello,

I have a matrix defined with the following columns as rows.
Options[Category Description],
Options[Option],
Community[_cCommunity with Number],
Options[_cPlan/Elev],
'Option Cost'[Cost Code]

And with the following measure for the value

'Option Cost'[_mOption Cost Code Count Diff]

I want to create a slicer using the 'Option Cost'[_mOption Cost Code Count Diff] measure, in order to filter out rows with values of zero.  I have created calculated tables in the past to do this, but not with multiple column/row levels.  Unfortunately, I can't make my pbix available. 

Looking for any suggestions/advice, thank you in advance.

@curtismob 

6 REPLIES 6
Daniel_PowerBI
Advocate I
Advocate I

Could it be this simple?

Daniel_PowerBI_0-1698445001754.png

 

This screen shot is from the link provided previously.

 

curtismob_0-1698931278313.png

 

Below is the calculated table used for the slicer, which has a relationship set with the Option table.

 

_tCost Code Count Slicer =
SUMMARIZE(
    Option,
    Option[Community],
    Option[Plan/Elev],
    "CountDiff", 'OptionCost'[_mCost Code Count Diff])

Unfortunately not, the requirement is to be able to toggle on/off including all values or exclude where the 'Option Cost'[_mOption Cost Code Count Diff] measure is zero.

Daniel_PowerBI
Advocate I
Advocate I

Can you supply a fake set in Excel or something?

Because we cant work with column names only

 

Maybe I can mock something up in Excel.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors