Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Using Column Chart results for a measure

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?

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    Anonymous ,

     

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

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.