Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
@JRe5777 ,
I'm really confuesd on your requirement. Could you please share some sample data and elaborate more on your requirement?
Regards,
Jimmy Tao
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |