The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Dear BI pros,
I hope you can help me with the following:
I am trying to count the processing steps that were performed on time for any given period.
But for some reason I am having problems with the DAX function:
@Anonymous - If this is a measure, you need to wrap column references in an aggregator so maybe try. @ me in replies
on time = CALCULATE(DISTINCTCOUNT(Processing Steps[Processing Steps No]),
Processing Steps[Processing Steps Status]="Finished",
USERELATIONSHIP(Processing Steps[Target Enddate],Date[Date]),
MAX(Processing Steps[Actual Enddate])<=MAX(Processing Steps[Target Enddate])))
If not, not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hi Greg,
thanks for your answer.
Yes, it is a measure I am trying to calculate.
I tried wrapping the date comparision with MAX, MIN, Filter...but it doesn't work. The message: Only a column reference is accepted as argument by the function 'MAX'.
Both date columns are formated as dates, although the 'Actual Enddate' is a calculated column pulling the dates from another table via RELATED.
I will try and see if I can setup a sample database.
Thanks
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |