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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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