Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
In my report I have a table which has columns "TYPE" ,"Meter Size".I have few conditions to display Type-
For the types which contains"TMS" then meter sizes"1,3/8,5/8" must be displayed.For other TYPES all Meter Sizes musst be displayed.
Solved! Go to Solution.
What you're looking for is something like this:
I'm using this measure:
IF(
CONTAINSSTRING(SELECTEDVALUE(T_MeterSize[Activity Type]),"TMS"),
"1,3/8,5/8",
SELECTEDVALUE(T_MeterSize[Meter Size])
)
Proud to be a Super User!
What you're looking for is something like this:
I'm using this measure:
IF(
CONTAINSSTRING(SELECTEDVALUE(T_MeterSize[Activity Type]),"TMS"),
"1,3/8,5/8",
SELECTEDVALUE(T_MeterSize[Meter Size])
)
Proud to be a Super User!
Hi @PavaniD,
Could you please provide more information about your issue?
A pbix with same data would be nice if it's possible to you or pictures of your data and formulas
Proud to be a Super User!
here is the report
For the types which contains"TMS" then "TMS TYPE" having meter sizes"1,3/8,5/8" must be displayed.For other TYPES all Meter Sizes must be displayed.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
66 | |
64 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |