Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Selecting a group by one value and creating an average

I'm fairly new to Power BI and writing dax, but reading answers in this forum has helped me a lot.  So, faced with a new problem I can't work out I thought I'd ask for some help. I have a spreadsh...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ashish_MathurThis is exactly what I was looking for, thank you very much!

In case anyone else is wondering it was a three measure combination of:

Count of facilities = DISTINCTCOUNT(Data[Facility Name])

Facilities with shortages = CALCULATE(COUNTROWS(Data),Data[Shortage]="Yes")

Measure = COUNTROWS(FILTER(VALUES(Data[Facility Name]),[Facilites with shortages]>0))/[Count of facilities]

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    You are welcome.