Visual Level filter on advance card

[Anonymous]

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 requeriment is to create three advance cards showing the percentage of users who registered by channel:

dax: R_Users = distinctcount([IdUser])

In my table I'm using a measure that is an absolute numbers but showing as % of grand total:

Now. I am trying to represent the information based on my table, but with cards, so I need to use three cards to show those %s. I'm doing this with visual level filters but is not working, it always shows 100%.

On visual level filters of each card, I'm usign the value of each channel and as I said, it is not working:

Is it possible to use visual level filters with advance cards? Or do I need to create a dax formula with the % of each channel?

Thanks in advance

[jdbuchanan71 · Accepted solution]

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]

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]

You would, yes.