Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |