Forum Discussion
Fairly simple median issue
Thanks. I think this is close as I'm not getting a formula error, but when I add the measure to the graph, it is blank. Here is my formula using my table and columns names. They only issue I see (bold) is your use of [Product ID], I assumed it should be my value column (actual hours), but I've also tried customer and left out columns.
1 Client Median = MEDIANX (
CALCULATETABLE (
VALUES ( 'Office Comparison'[Actual Hours] ),
FILTER (
ALLSELECTED ( 'Office Comparison' ),
'Office Comparison'[Customer] = SELECTED VALUE ( 'Office Comparison'[Customer] )
)
),
CALCULATE ( SUM ( 'Office Comparison'[Actual Hours] ) )
)
Hi hyndmanevanp
Thanks for your reply.
Have you find the solution now?
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
- hyndmanevanp4 years ago
Helper I
No, I have not found a solution.