Create a measure so I can show values of one filtered and one non filtered?

[Pandetbaby]

Hey!

So I want to create 1 line graph with 2 lines. 

One of the lines are % passed of the complete number of all registrered stores.

The second line will be % passed of only stores that were visited. 

It is impotant that I an get them in the same  graphs, so using filters on visuals wont work.

So say these are my numbers:

Stores Passed : 10

Store Visited: 50

Store in total: 100

I want this to show me 
% of total store passed: 10%

% of visited store passed: 20%

Thank you !

[JarroVGIT · Accepted solution]

You can create two measures and add them to your line table, like this one:

% Passed measure = DIVIDE([Stores Passed], CALCULATE(SUM(Table[Stores], ALL(Table))

,Without knowing what your datamodel looks like, it is guessing what the exact measure should be. But adding those measures to one line graph is very possible 🙂

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂