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.
I have columns ID, Name.
I'm using Text Filter to enter ID and filter the charts.
Requirement: I want the card to show Emp Name, if Length of the ID in the Text filter is equal to 10 characters.
Solved! Go to Solution.
Hello @ARUNTKAP,
Please try following measure:
EmpName =
VAR SelectedID = SELECTEDVALUE(Table[ID])
VAR IDLength = LEN(SelectedID)
VAR EmpName = CALCULATE(MIN(Table[Name]),FILTER(Table,Table[ID]=IDLength))
RETURN IF(IDLength>=10,EmpName,BLANK())
Hope this helps.
Hi @ARUNTKAP
Do you mean length of text used for seraching or length of result you get after search.
Example
your ids are
12345
45789
You type 123
So you are checking length of 123 or length of 12345?
If you are checking lengh of 123 then its not possible as text slicer is just used for searching purpose.
IF you want to check lenght of result after search that is 12345 then use below dax.
Hello @ARUNTKAP,
Please try following measure:
EmpName =
VAR SelectedID = SELECTEDVALUE(Table[ID])
VAR IDLength = LEN(SelectedID)
VAR EmpName = CALCULATE(MIN(Table[Name]),FILTER(Table,Table[ID]=IDLength))
RETURN IF(IDLength>=10,EmpName,BLANK())
Hope this helps.
Small correction I did to get the answer:
Instead of FILTER(Table,Table[ID]=IDLength))
FILTERTable,Table[ID]=selectedId))
Hi @ARUNTKAP
Do you mean length of text used for seraching or length of result you get after search.
Example
your ids are
12345
45789
You type 123
So you are checking length of 123 or length of 12345?
If you are checking lengh of 123 then its not possible as text slicer is just used for searching purpose.
IF you want to check lenght of result after search that is 12345 then use below dax.
Hi @Anonymous
Thanks for your input. I shall use your dax formulas in future, for my other need.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |