Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Visual Level filter on advance card

Hi,   I have a table with two values. One is my measure that is #users registered and the other value is the channel. I can add a table and show the percentage of users sliced by the channel. My r...
General Comment
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    Hello Anonymous 

    You should be able to do it with a singe measure.

    Pct of All Users =
DIVIDE ( 
    [R_Users], 
    CALCULATE ( 
        [R_Users], 
        ALL ( ChannelID ) 
    ) 
)

    Then you put that in a card and set the channel as a visual level filter.  That will control the chanel that feeds the numerator.

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

Hello Anonymous 

You should be able to do it with a singe measure.

Pct of All Users =
DIVIDE ( 
    [R_Users], 
    CALCULATE ( 
        [R_Users], 
        ALL ( ChannelID ) 
    ) 
)

Then you put that in a card and set the channel as a visual level filter.  That will control the chanel that feeds the numerator.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks jdbuchanan71  it worked perfect. As I am new to DAX, should I do this for all dimensions? Let's say I want to do this again, but for region. Should it look like this?:

     

    Pct of All Users Region =
DIVIDE ( 
    [R_Users], 
    CALCULATE ( 
        [R_Users], 
        ALL ( Region ) 
    ) 
)

     

    • jdbuchanan71's avatar
      jdbuchanan71
      Icon for Super User rankSuper User
      7 years ago

      You would, yes.