Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Bahalzamon
Helper I
Helper I

Compare slicer values to non-slicer values

So I have some phishing analytics I am making some graphics for (IMAGE 1). I have multiple clients, so this info is for Client A that is selected in the slicer. What I would like to do is show the averages of all the other clients so the current client can see where they stand in reference to other clients.

I have made an example of what it would look like in Excel (IMAGE 2).

 

I have a measure creating the failure rate percentage. But I am unsure how to show the values of the other Clients that are NOT selected in my slicer. I would of course like it to be dynamic so I can select another Client and the data updates based on the selected client and comparing it to all the other ones.

 

IMAGE 1

Bahalzamon_0-1699331114233.png

 

IMAGE 2

Bahalzamon_1-1699331243678.png

 

Any and all help would be greatly appreciated. 🙂

6 REPLIES 6
AbbasG
Memorable Member
Memorable Member

@Bahalzamon is this what you are trying to achieve??

Where you select a client from a slicer, and it also shows you the average values for that month for all the clients??

AbbasG_0-1699334628060.png


If yes, you can use the line and stacked column chart, and on the Line axis show the average values.

@AbbasG do you have any information on how you created your visual if its accomplishing anything similar to what i am requesting as it seems the thread is completely dead.

@AbbasG kind of, using your visual the bars would be the average for C1 and the line would be the average of C2 and C3.
If we want to get super fance i wouldnt be opposed to having multiple lines for each of the other clients, but one thing at a time lol

danextian
Super User
Super User

Hi @Bahalzamon 

Try below:

=
DIVIDE (
    [my measure],
    CALCULATE ( [my measure], ALLSELECTED ( 'table'[client] ) )
)

 

You can use

ALLSELECTED - the total is for all clients selected

ALL  - all clients in the table

 

 

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

@danextian i have tried a bunch of iterations and nothign is working.

i tried doing all, allexcept, allselected, allnoblankrow and can get none of it to work as i either get an error or everything is all teh same value  like all 25% or all 0%.

Hey @danextian 
I get what your doing but I am unable to identify how to impliment it into a final solution.

Here is my current measure for my existing visual. Do you think you can help guide me to what I am missing with the functions?

_Failure Rate =
COUNTROWS(
    FILTER(
        'Phishing/Training',
        'Phishing/Training'[clicked_at]<>BLANK()
    )
)
/
COUNTROWS(
    FILTER(
        'Phishing/Training',
        'Phishing/Training'[sent_at]<>BLANK()
    )
)

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors