User Profile
Arete
Helper I
Joined 3 years ago
User Widgets
Contributions
A transient error has occurred while applying table changes to SQL
My Lakehouse and SQL Endpoint were running fine until yesterday when errors appeared on several tables in the SQL Endpoint. The error message is: "A transient error has occurred while applying table changes to SQL. Please try again." This error has persisted for over 48 hours. We are using Shortcuts in the Lakehouse. Deleting the Shortcuts hasn’t resolved the issue or updated the SQL Endpoint. I can’t determine the root cause and would greatly appreciate any help or guidance!Re: Measure to calculate set over specified percentage
Hi Shaurya! I'm trying to create a new measure that returns the number of records that are greater than 0 in the Unique Entity % diff measure: In my data set there can be duplicate values with a different type: Record Value Type 1 John Doe Person 1 123 Main Street Address 1 111-11-1111 Social Security Number 1 111-11-1111 Passport Number In this example, the Total Entities is 4 and the Total Unique Entities is 3 and the % diff is higher than 0% so it should be counted.Re: Data modeling help with related records
Wow, thanks for this. There is a lot of data and it's taking forever to load. If I wanted to filter it to the Top 10 people by Count would you suggest I do so in the Flag measure or the calculated column? I believe I should use TopN but not entirely sure how to modify your DAX. v-jialluo-msftData modeling help with related records
Hi All! I have data structured in the following format: ID Type Value 100000000 Person John Doe 100000000 Address 123 Main Street 100000000 Phone Number 777-777-4444 100000001 Person Jane Doe 100000001 Address 123 Main Street 100000002 Person John Doe 100000002 Email [email protected] I'd like to either create a new table via Transform or a measure that organizes the data by Person: Name Count of ID Related Type John Doe 2 Address John Doe 2 Phone Number John Doe 2 Email Jane Doe 1 Address Essentially, I'd like to Group By Name and pull in all the Related Types where the ID match that name. Been stuck for hours and can't seem to figure it out. Thanks!Re: X-Axis Constant Line with RankX
Hi, FreemanZ thanks for the reply. Unfortunately, it's still not working. Is it because I'm using a measure in the RANKX? Entity Distribution X-Axis line = VAR tblRank = ADDCOLUMNS( 'Top 250 Entities', "Rank", RANKX( 'Top 250 Entities', [Total Entities], , DESC ) ) RETURN MINX( FILTER(tblRank, [Rank] = 10), [Total Entities] ) The Total Entities measure is just a count: Total Entities = CALCULATE( COUNT('Top 250 Entities'[NER_PII_Values]) ) Your suggestion comes back with Blank when it should be 71.624:X-Axis Constant Line with RankX
Hello Community! I'd like to put an X-Axis Constant line on a Scatter Chart for the 10th largest Entity and I've created 3 measures: Total Entities = CALCULATE( COUNT('tbl'[NER_PII_Values]) ) Total Entities Ranking = RANKX( ALL('tbl'[NER_PII_Values]), [Total Entities], ,DESC ) Entity Distribution X Constant = VAR TotalEntityRanking = [Total Entities Ranking] RETURN CALCULATE( [Total Entities], FILTER( 'tbl', TotalEntityRanking = 10 ) ) On the Matrix, it looks great but when I use the measure in conditional formatting it shows as 0: I'm expecting a line at 71,656. Thank you in advance!
