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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

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.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.