User Profile
gaccardo
Advocate II
Joined 8 years ago
User Widgets
Contributions
Re: Gantt chart buggin after update
I can duplicate this error message with two stacked bar charts. Each chart has a value for the axis, and the count of another value for the value field. With both charts, I am able to click and ctrl-click values to cross filter things. In one of the charts, I add the same value used in the axis as the legend, then turn the legend off. Effectively, I have the same chart as before, but all the bars are now different colors. By clicking and ctrl-clicking to cross filter by two things (same as before), I can get at least one of the charts to fail to display with the error message shown in the original post. If there are other visuals on the page, all of them also fail. Currently, there are two work arounds for this. The first is that I duplicate the column used for the axis, and use this duplicated column in the legend. The second is that I don't use a legend at all, and set colors individually. Feedback Type: Frown (Error) Timestamp: 2018-10-18T12:24:44.9832896Z Local Time: 2018-10-18T07:24:44.9832896-05:00 Session ID: f24eafc7-41e9-4dce-85fd-db1c057e5b79 Release: September 2018 Product Version: 2.62.5222.761 (18.09) (x64) Error Message: The duplicate expressions in the In filter do not have identical values. They cannot be deduped.1.3KViews0likes0CommentsHow to eliminate a circular dependency?
I added the following column to a table named 'User Story'. It uses a relationship that is disabled because it is redundant and only useful for this particular set of calculations. The values calculated for each row are correct. Count of Failing Tests = COUNTROWS ( CALCULATETABLE ( 'Test Case Most Recent Result', USERELATIONSHIP ('User Story'[WorkItemId], '_Relation'[WorkItemId]), 'Test Case Most Recent Result'[Outcome] = "Failed" ) ) The problem comes when I add a nearly identical column. The only difference is that instead of results with an outcome of "Failed", I want to calculate the ones with an outcome of "Passed." Count of Passing Tests = COUNTROWS ( CALCULATETABLE ( 'Test Case Most Recent Result', USERELATIONSHIP ('User Story'[WorkItemId], '_Relation'[WorkItemId]), 'Test Case Most Recent Result'[Outcome] = "Passed" ) ) When I try to add this column, I get the following message about circular dependencies. A circular dependency was detected: User Story[Count of Passing Tests], User Story[Count of Failing Tests], User Story[Count of Passing Tests]. How is this circular? Is there a general pattern for counting the rows in a related table, specifying both a relationship and a filter? Any help is greatly appreciated.Solved11KViews0likes1CommentOff-by-One Error using COUNTX() and ALL()
I have an issue when using COUNTX () with the ALL() function. The value returned is the actual number of rows plus one. I've verified this with a bunch of tables, and I've got a solution, specifically using the ALLNOBLANKROW() function instead of ALL(). What I don't know is why this is necessary or if this is a proper pattern to use for solving counting all the rows that meet a particular condition. Any suggestions would be appreciated. This DAX returns the correct answer, but I don't know why or if this is a correct pattern to use. All Requirements without User Stories = VAR counter = COUNTX( ALLNOBLANKROW('Requirement'), IF( [Count of Related User Stories] < 1, 1, BLANK() ) ) RETURN IF ( ISBLANK (counter), 0, counter ) This DAX returns a number that is the correct number plus one. Why? All Requirements without User Stories = VAR counter = COUNTX( ALL('Requirement'), IF( [Count of Related User Stories] < 1, 1, BLANK() ) ) RETURN IF ( ISBLANK (counter), 0, counter )Solved1.7KViews0likes2CommentsRe: How to I get summarized results of a filtered table?
Thank you for your reply Anonymous. I tried the DAX below, but it does not work properly. It shows exactly the same results regardless of the values selected in the slicer. I've also tried using ALLSELECTED('Bug'), but it, too, gives the same results. I suspect that the SUMMARIZE is running when there is no context for SELECTEDVALUE and that a much different solution is required. Bug Summary = SUMMARIZE( FILTER ( 'Bug', 'Bug'[State] = SELECTEDVALUE('Bug'[State] ) ), Bug[Created Date Only], "Count", COUNT(Bug[Days Open]), "Days Open Average", AVERAGE(Bug[Days Open]), "Days Open Minimum", MINA(Bug[Days Open]), "Days Open Maximum", MAXA (Bug[Days Open]) )4KViews0likes0CommentsHow to I get summarized results of a filtered table?
I have a table called Bugs. It has numerous attributes, such as functional area, state, impact, etc. in addition to a calculated column call [Days Open]. I also have a summary table, created as follows: Bug Summary = SUMMARIZE( 'Bug', 'Bug'[Created Date], "Count", COUNT('Bug'[Days Open]), "Average Days Open", AVERAGE('Bug'[Days Open]), "Min Days Open", MINA('Bug'[Days Open]), "Max Days Open", MAXA ('Bug'[Days Open]) ) The report also has numerous slicers that filter the bug table by the various attributes. I would like to see the summary based not on the entire bug table, but only on the bugs that are selected by the various slicers. In other words, as I update the slicers, I would like to recalculate the summary table. How can I do this? Any help is greatly appreciated.Solved4KViews1like4Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.