Forum Discussion
Solved
Avoid repeating values for multiple fields placed in matrix visual in Values section.
Hi , I have the following requirement , i have below table which i am showing in a matrrix visual . Rows: Emp no and name Columns : Category values : total count Now i need to calculate ...
I do not fully understand what you need, but look at my file, it can help you
pls try this
dumpCategory = ADDCOLUMNS(
UNION(DISTINCT('Table'[cat]),{"Overall Category"}), "Order",
SWITCH( TRUE() ,
[cat]= "Category 1",1,
[cat]= "Category 2",2,
[cat]= "Category 3",3,
[cat]= "Category 4",4,
[cat]= "Overall Category",5
))
Hi Ahmedx , I tried usint below measure ,
For table , the values are not getting sorted correctly in power bi , and getting blank values.
For Measure : I am getting Circular dependency.
Please advice.
Table :
Em category =
ADDCOLUMNS(
UNION(
DISTINCT(HC_Master[EM Comments Category]),
{"Bench %","Bench Count","Billable %","Grand Total"})
,"Order",
SWITCH(TRUE(),
HC_Master[EM Comments Category] ="Bench",1,
HC_Master[EM Comments Category] ="Billable",2,
HC_Master[EM Comments Category] ="Blocked",3,
HC_Master[EM Comments Category] ="Proposed",4,
HC_Master[EM Comments Category] ="Long Leave - ML",5,
HC_Master[EM Comments Category] ="PPED",6,
HC_Master[EM Comments Category] ="Grand Total",7,
HC_Master[EM Comments Category] ="Bench Count",8,
HC_Master[EM Comments Category] ="Bench %",9,10
//HC_Master[EM Comments Category] ="Billable %",10
))
Measure
Sorting = SWITCH(TRUE(),
'Em category'[EM Comments Category] ="Bench",1,
'Em category'[EM Comments Category] ="Billable",2,
'Em category'[EM Comments Category] ="Blocked",3,
'Em category'[EM Comments Category] ="Proposed",4,
'Em category'[EM Comments Category] ="Long Leave - ML",5,
'Em category'[EM Comments Category] ="PPED",6,
'Em category'[EM Comments Category] ="Grand Total",7,
'Em category'[EM Comments Category] ="Bench Count",8,
'Em category'[EM Comments Category] ="Bench %",9,10
//'Em category'[EM Comments Category] ="Billable %",10
)
Share sample pbix file to help you.