cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Count how many itens in the column AVERAGE are Greater Than MEDIAN

Hi,

I have this example in my onedrive. Link: https://1drv.ms/f/s!As8YC7wZr8RKist1_Ql70SsOKar7yA

I create the measure MEDIAN. I would like to count how many itens in the Subcategory column Greater Than the MEDIAN.

Could this calculation be done as a measure, not column?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Count how many itens in the column AVERAGE are Greater Than MEDIAN

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Count how many itens in the column AVERAGE are Greater Than MEDIAN

HI @vazfelipe

 

The folder is empty


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Highlighted
Frequent Visitor

Re: Count how many itens in the column AVERAGE are Greater Than MEDIAN

Ops, my bad!

 

Attached in this moment. Please do you know how to count AVG in a row context using a measure?

Highlighted
Frequent Visitor

Re: Count how many itens in the column AVERAGE are Greater Than MEDIAN

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors