Forum Discussion
Values derived based on multipe criteria
Hi All, I am new to PowerBi and working on solution wherein I have to determine the value of Country based on Product Category. Let's take an example so that it can be clear:- Year Country ...
Diptarup ,
Create a new column
Switch ( True(),
[Sub - Category] in{ "C1","C2","C3","C4"} , "Group 1",
[Sub - Category] in{ "C5","C6","C7","C8"} , "Group 2",
[Sub - Category] in{ "C9","C10","C11","C12"} , "Group 3"
)
Create a new measure
Avg Value = averagex(Values(Table[Group]), calculate(sum(Table[Value])))
Not working, it is giving the sum value. Results I am getting are 6.33, 5.67, 10.00
