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.
I have table1[name]
and Mesuare=
var sum1 = [mesuare1] - [measure2]
var sum2 = [mesuare3] - [measure4]
RETURN
SWITCH(TRUE(),
DISTINCT(Table1[name]) = "Name1", sum1,
DISTINCT(Table1[name]) = "Name2", sum2
)
It work wel while table1[name] has no dublicates, if table1[name] have dublicate name measuare not work, why?
MdxScript(Model) (253, 43) Calculation error in measure '[Measure]: A table of multiple values was supplied where a single value was expected.
Solved! Go to Solution.
Hi, @Analitika
Distinct function returns a one-column table that contains the distinct values from the specified column. In other words, duplicate values are removed and only unique values are returned.
You may try the following measure to see if it works.
Mesuare =
VAR sum1 = [mesuare1] - [measure2]
VAR sum2 = [mesuare3] - [measure4]
RETURN
SWITCH (
TRUE (),
"Name1" IN DISTINCT ( Table1[name] ), sum1,
"Name2" IN DISTINCT ( Table1[name] ), sum2,
BLANK ()
)
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Analitika
Distinct function returns a one-column table that contains the distinct values from the specified column. In other words, duplicate values are removed and only unique values are returned.
You may try the following measure to see if it works.
Mesuare =
VAR sum1 = [mesuare1] - [measure2]
VAR sum2 = [mesuare3] - [measure4]
RETURN
SWITCH (
TRUE (),
"Name1" IN DISTINCT ( Table1[name] ), sum1,
"Name2" IN DISTINCT ( Table1[name] ), sum2,
BLANK ()
)
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Analitika , try
Measure=
var sum1 = [mesuare1] - [measure2]
var sum2 = [mesuare3] - [measure4]
RETURN
SWITCH(TRUE(),
max(Table1[name]) = "Name1", sum1,
max(Table1[name]) = "Name2", sum2
)
But with MAX() not work if table has no dublicates 😫
you should define cell for compare more accurate. like
Mesuare=
var sum1 = [mesuare1] - [measure2]
var sum2 = [mesuare3] - [measure4]
var currentName = MAX(Table1[name])
RETURN
SWITCH(TRUE(),
currentName = "Name1", sum1,
currentName = "Name2", sum2,
BLANK()
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |