Forum Discussion

binayjethwa's avatar
binayjethwa
Helper V
3 years ago
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 ...
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago

Share sample pbix file to help you.

show measure [Bench %]

binayjethwa's avatar
binayjethwa
Helper V
3 years ago

Hi Ahmedx ,

 

i think i was using filter from master table instead of category table. THis is working now , But i need to add multiple values so i added as below.

 

category = UNION(DISTINCT(Master[Comments Category]),{"Bench %","Bench count","Billable %"})

 I have separate measures created for Bench %  , Billable % etc

 

and i used switch in overall measure and if selected = Bench % retuen Bench % measure  selectedvalue = Billable % return Billable % and so on , and i changed any filters coming from category table only from master table. But it is only working for one values.

 

please let me know if i am missing anything here

 

 

My overall measure=

 

VAR benchcount = [Bench count]
VAR overallcount = DISTINCTCOUNT(HC_Master[GPN])
VAR billablecount = CALCULATE(DISTINCTCOUNT(HC_Master[GPN]),'Em category'[EM Comments Category]="Billable")
return
SWITCH(TRUE(),
SELECTEDVALUE('Em category'[EM Comments Category]) = "Bench Count",[Bench count],
SELECTEDVALUE('Em category'[EM Comments Category]) = "Bench %",DIVIDE(benchcount,overallcount),
SELECTEDVALUE('Em category'[EM Comments Category]) = "Billable %",DIVIDE(billablecount,overallcount),DISTINCTCOUNT(HC_Master[GPN]))