Percentage of Data Above Median Line Based on Category

[Teach_Me_Dax]

I am happy to share my full data set and full dashboard if someone can tell me how to do that. for now I'll post pictures. 

Info: OVR Median is the Overall median of my full data set. the full data set is bigger than what is shown here. 

Info: Table_1 and Table_2 have a relationship with the "Date" Fields. 

I want to make a card like this one for my current data set 

This card is from a different dashboard. I had to use DAX to make the card, but this was a while ago and I do not know how to replicate this within my current data set 

This is my current dashboard below. There are 2 categories for the data. Category 1 is "FOMC Meetings", and Category 2 is "Earnings." 

I would like to take to make a card like this. 

Range Above OVR Median for FOMC Meeting Dates 

(Divided by) 

Count Range for FOMC Meeting Dates 

I want the result to show me a big Card that reads 

85% FOMC Meeting dates are above OVR Median 

or 7/8 FOMC Meeting dates are above OVR Median 

again i am happy to provide all my dashboard and all my data if someone can  tell me how to do that. big thankyou in advance to anyone who helps. 

[Anonymous]

Hi @Teach_Me_Dax ,

I think you can add a filter like [Data] >= Median (7) in COUNT() Code to count FOMC Meeting dates which are above OVR Median. Then count all and divide total by the count above.

Your calculation is based on your data model. Please share a easy sample file with me and show me a screenshot with the result you want. This will make it easier for me to find the result.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.