Forum Discussion
Helper IField Parameter with total bar
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
No need for Field Parameters. Unpivot your data to bring it into a usable format and then use regular filters.
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
Mokegubshook Have you tested it?
if it's ok please accept the answer as solution to help other users.
BBF
3 Replies
- lbendlin
Super User
No need for Field Parameters. Unpivot your data to bring it into a usable format and then use regular filters.
- BeaBF
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
Mokegubshook Have you tested it?
if it's ok please accept the answer as solution to help other users.
BBF