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.
Hi! I have this measure:
Measure =
VAR FECHA = CALCULATE(MIN('DATA BASE'[DATE]),ALLSELECTED('DATA BASE'[DATE]),VALUES('DATA BASE'[resp x dep 2]))
RETURN FECHA
and in my table is returning me this:
i want to force the measure to only display the values that have information in the MIN date selected in the slicer. Similar as when I select the specific date:
I will use this variable for another measure
Thank you for the help!!
@Midguel , try like
Measure =
var _min = minx(allselected('DATA BASE'),'DATA BASE'[DATE])
RETURN
CALCULATE(MIN('DATA BASE'[DATE]),filter('DATA BASE','DATA BASE'[DATE]=_min ))
The slicer needs to be fed from an independent date table.
Create a measure that compares your fact date to the min slicer date
Show Row :=
VAR FECHA = MIN('SLICER'[DATE])
Return 'DATA BASE'[Start]=FECHA
Then filter the visual by Show Row = True
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |