Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
could you help me to create a measure that ruturn an string depending of the selection?
IF is one value of the column is selected then that value from the column else
IF 2 or more values from the column are selected then "MULTIPLE VALUES SELECTED" else
IF all values from the column are selected then "ALL SELECTED"
How can I build this ?
this will based on the column :
Market Unit |
Africa |
AFS |
ANZ |
ASGR |
Canada |
Gallia |
Greater China |
Iberia |
ICEG |
India |
Japan |
Latin America |
ME |
Midwest |
Nordic |
Northeast |
SEA |
South |
UK, Ireland |
US Not Assigned |
West |
NOT ASSIGNED |
United States |
Solved! Go to Solution.
Hi @amitchandak ,
Tables are connected and calculate(sum(Table[Value]) is not what I was looking for.
Finally I got the solution with the following measure:
@cristianml , if the table are disconnected , if they are joined it should happen automatically
calculate(sum(Table[Value]), filter(Table, Table[Market Unit] in values('List MU'[Market Unit])))
Hi @amitchandak ,
Tables are connected and calculate(sum(Table[Value]) is not what I was looking for.
Finally I got the solution with the following measure:
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |