Using Column Chart results for a measure

[JRe5777]

Hello everybody, 

I dont know if this is possible but let me know what you think.

So I have a column chart where the X axis is column A of my table and Y axis is a measure using other tables values.

(the measure is to calculate an average of values for either F, M or the global average)

Measure = 
VAR s = SELECTEDVALUE ( Table1[ColumnA] )
VAR currentDate =
    MAX ( 'Datas'[Date] )
RETURN
    IF (
        s = "Global",
        CALCULATE (
            SUM(Table2[Value]),
            Table2[Start_Date] <= currentDate,
            OR(ISBLANK(Table2[End_Date]),
            Table2[End_Date] > currentDate))/COUNT(Table3[Employee ID]),
        CALCULATE (
            SUM(Table2[Value]),
            Table2[Start_Date] <= currentDate,
            OR(ISBLANK(Table2[End_Date]),
            Table2[End_Date] > currentDate),Table3[F/M] = s)
        /COUNT(Table3[Employee ID])
    )

So there are 3 values in the column A, and so my column chart has 3 columns.

Is it possible to have M/F ? I want a single value with the operation of (in this case) 1265/1812

Can we do this?

[v-yuta-msft]

@JRe5777 ,

I'm really confuesd on your requirement. Could you please share some sample data and elaborate more on your requirement?

Regards,

Jimmy Tao

[JRe5777 · Accepted solution]

Nevermind, I was complicating to much.

I just have to adjust my measure (which is calculating an average) so that both numerator and denominator have the same filter condition.

Then I add another measure which will divide one average per another, as my goal was to have the ratio between the 2 measures.

Maybe its a bit specific for me and it won't help anyone so I will mark my answer as the solution.

Thanks anyway.