Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
MAVIE
Helper I
Helper I

Count from SUMMARIZE over time

Hi All,

 

I'm trying to visualize how many bugs were opened or closed over time. 
For this my data consists of a table with BugVersions and their statuses, as well as a date table.

As I only want dates when the bugs were Opened/Closed I want the first version when they have either status "New" or "Done".

In order to do this I have been trying to use SUMMARY to look at the first date with either status, however when this is evaluated in the context of the date table, then all version still apear. 
The measure that I have so far looks as such: 

MAVIE_0-1678282685680.png

For reference the SUMMARY table that I am creating looks as such: 

MAVIE_2-1678283457738.png

 

Filtered on one bug, I get the following visual, from which I want to remove all lines, but the first green and first red

MAVIE_1-1678282783308.png

 

Any help would be greatly appreciated

3 REPLIES 3
tamerj1
Super User
Super User

@MAVIE 

Please try

Measure2 =
VAR T =
ALLSELECTED ( 'Date'[Year] )
RETURN
IF (
SELECTEDVALUE ( 'Date'[Year] )
IN { MINX ( T, 'Date'[Year] ), MAXX ( T, 'Date'[Year] ) },
[Measure]
)

Hi @tamerj1 

Thank you for your help. 

Unfortunately, the measure only filters the date dimension to the current year, but does not filter the bug versions. 

The fix that I am trying to achieve is one that applies a filter on my table FactBugs_T2, such that I only get the earliest version of the "Bug" where it has status "New" and "Done" for each day in my date dimension. 

For that reason I have been trying to use the following measure 

 

 

Measure =
VAR BugGroup = 

    CALCULATETABLE(
        SUMMARIZE (
              FactBugs_T2,
              FactBugs_T2[BugID],
              FactBugs_T2[BugType],
              FactBugs_T2[LookupStatusType],
              "FirstVersion",
              MIN ( FactBugs_T2[VersionCreated] )
        ),
        FactBugs_T2[LookupStatusType] IN {"New","Done"}
    )

RETURN 
COUNTROWS ( BugGroup )

 

 

This does not seem to apply the filters to FactBugs_T2[VersionCreated] in the right context. 
 
If I first create a calculated table with same code as in VAR BugGroup, and then creates a measure to COUNTROWS on that, then I get the correct result, however then other slicers from my report do not work with the measure. 
I hope that makes sense.
MAVIE
Helper I
Helper I

I have been able to get the correct result by first creating a calculated table and then creating a count based on that. 

MAVIE_1-1678369667006.png

 

However this is not satisfactory, since I cannot use the same slicers for both the calculated table and the FactBugs_T2 table.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.