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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ERAHUMO
Frequent Visitor

Using a Field Parameter in a Measure

I have written the below DAX function:

 

Slicer_Filter =
VAR Virtual =
SELECTCOLUMNS (
        SUMMARIZE ( 'X-Parameter', 'X-Parameter'[X-Parameter], 'X-Parameter'[X-Parameter Fields] ),
        "Sales", [Count_EID]
    )
VAR MINVALUE = MINX(Virtual, [Sales])
VAR MAXVALUE = MAXX(Virtual, [Sales])
VAR CURRENTSLICERVALUE = SELECTEDVALUE('EID_Count_Parameter'[EID_Count_Parameter])
RETURN
IF(
    CURRENTSLICERVALUE>=MINVALUE && CURRENTSLICERVALUE <=MAXVALUE,
    1,
    0
)
 
This is to be used on a slicer which is created using Numeric Field Parameter.
Now i am able to use this properly except the slicer shows max value in MIN value box (Slicer is between slicer.)
X-Parameter is a Field parameter.
 
How can we solve for this? I cant share the pbix file but if there is anything more information requried please let me know.
1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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