Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX

Hi,   I have 2 queries, 1. I have a matrix where the values are in % and I want the total in numbers, Is it possible to get like that   2. I have created a closure TAT with respect to Complaint ...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , Create a column group. Have same name for other other than the first two, which you group under closed in 2 hrs-overall

 

example

 

Switch(True(),

[Status] in {"Closed in 2 hrs-weekdays", "closed in 2 hrs-weekend" } , "closed in 2 hrs-overall",

[Status] )

 

you can use them to two-level

 

or you can use other for all other

 

Switch(True(),

[Status] in {"Closed in 2 hrs-weekdays", "closed in 2 hrs-weekend" } , "closed in 2 hrs-overall",

"Others")