Wishmaster89
Board Regular
- Joined
- Jan 10, 2022
- Messages
- 77
- Office Version
- 2021
- 2019
- 2016
- Platform
- Windows
- MacOS
Hey guys
I am new to Power BI and i'm trying to replicate a report i have in excel/power query. I just want a measure to do a count based on two conditions but i can't get it to work, here is what i have tried.
I am new to Power BI and i'm trying to replicate a report i have in excel/power query. I just want a measure to do a count based on two conditions but i can't get it to work, here is what i have tried.
Code:
Continuing learners = COUNTX (fILTER('AP Numbers final merge','AP Numbers final merge'[AP numbers.ILR Aims.Status]=1), 'AP Numbers final merge'[AP numbers.ILR Aims.Outcome]=8)