Forum Discussion
Mokegubshook
Helper I
1 year agoField 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 shou...
- 1 year ago
No need for Field Parameters. Unpivot your data to bring it into a usable format and then use regular filters.
- 1 year ago
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
- 1 year ago
Mokegubshook Have you tested it?
if it's ok please accept the answer as solution to help other users.
BBF
lbendlin
Super User
1 year agoNo need for Field Parameters. Unpivot your data to bring it into a usable format and then use regular filters.