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.
I have the following DAX code in my PBI file. I have only changed the data sources from .xlsx files to .csv files. All the data and datatypes are identical. After changing the data sources though, this code gives me an error:
MAX_User =
CALCULATE(
MAXX(
ALLSELECTED('CALC NP''s (Unique)'),
'CALC NP''s (Unique)'[User]
),
GROUPBY(
'CALC NP''s (Unique)',
Date[Week],
'CALC NP''s (Unique)'[Patiëntnumber]
)
)
For 'Date[Week]' it now suddenly says 'Parameter is not the correct type'. Does anyone have an idea of why this is?
Solved! Go to Solution.
@Sohan , Check your relationships. I think that has broken, It may happen when changes sources from one type to another
Thank you so much! The relationship was indeed broken for some reason.
User | Count |
---|---|
83 | |
83 | |
37 | |
34 | |
32 |
User | Count |
---|---|
92 | |
79 | |
62 | |
53 | |
51 |