Sum the data of two tables with filters and then make a division after

[karn]

Hi,

I have two views with identical structure :

Contains all lines :

Contains only those who answered 1

I want to divide the sums grouped by marks / periods of each tables and be able to filter by sex or age in Power Bi

So I think I have to first make my sums with the filters of each table to be able to then make my division between result.

I want this result :

But how i can do ?

Thank !

[v-chuncz-msft · Accepted solution]

@karn ,

Just try using SUM and DIVIDE to add a measure.

[v-chuncz-msft · Accepted solution]

@karn ,

Just try using SUM and DIVIDE to add a measure.

[karn · Accepted solution]

Thank you 🙂

Here is how I solved my problem :

ValCal =

DIVIDE(

CALCULATE(COUNT(D_NQ2AA[id]); D_NQ2AA[Val] = 1);

COUNT(D_NQ2AA[id])

)*100