Forum Discussion
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.)
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
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-Forum/ba-p/963216
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/1447523
