Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Help! I am about to melt down into a puddle of frustration over something that has to be simple.
I have super simple table with measures that used to work prior to a crash. The table at issue looks like this: (simple!)
Post recovery, I lost my DAX measures for this table. No problem - they were simple for this part of the model....EXCEPT that now when I go to recreate those measures, DAX no longer recognizes my column headers. Images below. What in the world am I doing wrong?
Note: I understand that I could, as a work around, (i) use power query to add the date as a new column, and (ii) define as measures themselves my table's columns (like Event Value and Total Events. But, alas, I am stubborn and vexed by what I am missing that makes the column headers no longer work for measures.
Additional point: I promoted headers, changed the columns to numbers, etc (m languate below)
let
Source = Csv.Document(File.Contents("C:\Users\Open Use\Local Posts By Ed.csv"),[Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Event Value", Int64.Type}, {"Total Events", Int64.Type}, {"patch id", Int64.Type}}),
#"Changed Type" = Table.TransformColumnTypes(#"Changed Type1",{{"patch id", Int64.Type}, {"Month Index", Int64.Type}, {"Date", Int64.Type}, {"Event Value", Int64.Type}, {"Total Events", Int64.Type}})
in
#"Changed Type"
Thank you for any advice!!!
Solved! Go to Solution.
Hi, the problem is in a measure you need to put a aggregation or function.
Example
Measure= Right(SelectedValue(Table1[Column]))
Maybe before the crash of your file they are calculated columns not measures.
Regards
Victor
Could you reporduce this issue using a sample pbix file and share the sample pbix file?
Regards,
Jimmy Tao
let
Source = Csv.Document(File.Contents("C:\Users\Open Use\Local Posts By Ed.csv"),[Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Event Value", Int64.Type}, {"Total Events", Int64.Type}, {"patch id", Int64.Type}}),
#"Changed Type" = Table.TransformColumnTypes(#"Changed Type1",{{"patch id", Int64.Type}, {"Month Index", Int64.Type}, {"Date", Int64.Type}, {"Event Value", Int64.Type}, {"Total Events", Int64.Type}})
in
#"Changed Type"
Thank you for any advice!!!
It seems like the column names has been changed in power query(e.g.: change column names, promoted Headers, delete/add columns), have you click apply&close after the last modification in power bi? If you have, modify the column names in the report level and click refresh.
Regards,
Jimmy Tao
2 things:
1 - The names match the source CSV column names and remain unchanged
2 - I tried changing names and rerunning, and got the same result.
I ended up just doing the manual workaround. If there's nothing obvious I'm doing wrong, I'd say this one smells like a bug that can occur when a file crashes and recovers.
Hi, the problem is in a measure you need to put a aggregation or function.
Example
Measure= Right(SelectedValue(Table1[Column]))
Maybe before the crash of your file they are calculated columns not measures.
Regards
Victor
User | Count |
---|---|
93 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |