Forum Discussion

Mokegubshook's avatar
Mokegubshook
Icon for Helper I rankHelper I
1 year ago
Solved

Field 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...
  • lbendlin's avatar
    1 year ago

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

  • BeaBF's avatar
    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

  • BeaBF's avatar
    BeaBF
    1 year ago

    Mokegubshook Have you tested it?

     

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

     

    BBF