cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Row context measure

Hello everyone,

 

Need some help.

I have Project KPI board. Everything was fine till that point, where I had to calculate how much Bad projects are?

I think it's because Status measure I calculated is not row based.

 

 

Status = IF([CPI]>0,7; "Good";IF([CPI]>0,5; "Need attention";"Bad"))
CPI = [EV]/[Worklog]
Spoiler
EV = CALCULATE(  SUM(jira[Billabe Hours]); FILTER(jira;jira[Resolution]<>BLANK()))
Worklog = SUM(Worklog[WorklogHours])

 

 

I looked through some posts, but I couldn't get right DAX to fit.

 

Can anyone help me, this is pbix file:

https://drive.google.com/file/d/1gQyMKnEirfIYimoI1sMVfftAT0mBOWQW/view?usp=sharing

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Row context measure

HI @Anonymous ,

Based on my understand, In your scenario, the CPI of Project 2 and 3 are less than 0.5, then the result will be 2.

You can use the following DAX query:

Measure =
VAR a =
    ADDCOLUMNS ( VALUES ( Component[Project] ), "CPIa", [CPI] )
RETURN
    COUNTROWS ( FILTER ( a, [CPIa] < 0.5 && Component[Project] <> BLANK () ) )

The measure you shared will not get the true data, the [CPI] is a measure, it will be calculated based on the filter, but in the measure "BAD Project", it will not have the context of Project names.

Best Regards,

Teige

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Row context measure

Hi @Anonymous ,

Based on my check, I haven't found problem in your DAX query, could you please tell me what's problem did you meet?

Best Regards,

Teige

Anonymous
Not applicable

Re: Row context measure

Thanks, @TeigeGao for the replay

 

Problem is by calculating the number of BAD projects.

The measure

BAD Project = CALCULATE(DISTINCTCOUNT(Component[Project]);FILTER(Component;[CPI]<0,5))
Doesn't work it brings all projects
Community Support Team
Community Support Team

Re: Row context measure

HI @Anonymous ,

Based on my understand, In your scenario, the CPI of Project 2 and 3 are less than 0.5, then the result will be 2.

You can use the following DAX query:

Measure =
VAR a =
    ADDCOLUMNS ( VALUES ( Component[Project] ), "CPIa", [CPI] )
RETURN
    COUNTROWS ( FILTER ( a, [CPIa] < 0.5 && Component[Project] <> BLANK () ) )

The measure you shared will not get the true data, the [CPI] is a measure, it will be calculated based on the filter, but in the measure "BAD Project", it will not have the context of Project names.

Best Regards,

Teige

View solution in original post

Highlighted
Anonymous
Not applicable

Re: Row context measure

Thanks, @TeigeGao it worked!

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors