Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Sohan
Helper III
Helper III

DAX average of two attributes from two tables

I have three measures. 

  1. Calculated the number of appointments a practitioner has.
    CALCULATE(COUNT(Afspraken[Patiëntnummer]),
    FILTER(Afspraken, Afspraken[Soort afspraak]<>"Phone call"),
    FILTER(Afspraken, Afspraken[Status]="Done"))

  2. Calculated the revenue generated by said practitioner.
    CALCULATE(SUM(Verkoopboekingen[Bedrag (excl. belastingen)]),
    FILTER(Verkoopboekingen, Verkoopboekingen[Grootboekrekening]<>8505))

  3. The division of the two above.
    DIVIDE('Gemiddelde behandelomzet per dag'[Omzet per dag], 'Gemiddelde behandelomzet per dag'[Aantal afspraken])
     
    However number three does not give the correct value back. Does anyone know why?
     
    Sohan_0-1617710221566.png

     

1 REPLY 1
amitchandak
Super User
Super User

@Sohan , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Try the first one like this and check

CALCULATE(COUNT(Afspraken[Patiëntnummer]),
FILTER(Afspraken, Afspraken[Soort afspraak]<>"Phone call" && Afspraken[Status]="Done"))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.