Field Parameter with total bar

[Mokegubshook]

I have data looklike table Usage below. I need filter to select P90, P95 and P99.

If select P90 it should calculate P90 data of each Chanel (Computer and Phone) with total. 

My output should looklike:

What I do now is create field parameter for P90,P95 and P99, but cannot do the total of them. 

If you have any solution that would be great!!

Thank you sp much

[lbendlin · Accepted solution]

No need for Field Parameters.  Unpivot your data to bring it into a usable format and then use regular filters.

[BeaBF · Accepted solution]

@Mokegubshook Hi!

Let's build a Table like:

you can easily construct it with the "Enter Data" Button:

Don't make a relationship!

Then calculate this measure:

Measure = SWITCH(SELECTEDVALUE(P_Table[P]),

"P90", SUM('Table'[P90]),

"P95", SUM('Table'[P95]),

"P99", SUM('Table'[P99]))

You'll achieve the expected output:

BBF

[BeaBF · Accepted solution]

@Mokegubshook Hi!

Let's build a Table like:

you can easily construct it with the "Enter Data" Button:

Don't make a relationship!

Then calculate this measure:

Measure = SWITCH(SELECTEDVALUE(P_Table[P]),

"P90", SUM('Table'[P90]),

"P95", SUM('Table'[P95]),

"P99", SUM('Table'[P99]))

You'll achieve the expected output:

BBF

[BeaBF · Accepted solution]

@Mokegubshook Have you tested it?

if it's ok please accept the answer as solution to help other users.

BBF

[lbendlin · Accepted solution]

No need for Field Parameters.  Unpivot your data to bring it into a usable format and then use regular filters.