cancel
Showing results for
Did you mean:
Regular Visitor

## Total Value Columm Measure

Hi
wanna have a measure that allows to calculate the number of "points" u win if your percentage is in a specific range for example for week 35 my percentage is 71%, this number is beetween -9 and 1 so i won 0 points. Also, my Total should give the summ of points won so far

i accomplished the first part by using this measure:

CALCULATE(VALUES(Scorecard[Puntos]),FILTER(Scorecard,[SalyTo19]>=Scorecard[Desde]&&[SalyTo19]<Scorecard[Hasta]))

however the GrandTotal is not giving me the right number so after reading a lot of similar posts i tryed to use this other measure:

IF(HASONEFILTER(Table1[Week]),

CALCULATE(VALUES(Scorecard[Puntos]),FILTER(Scorecard,[SalyTo19]>=Scorecard[Desde]&&[SalyTo19]<Scorecard[Hasta])),
SUMX(Table1,(VALUES(Scorecard[Puntos]))

but no luck so far

can anyone help me with this?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Total Value Columm Measure

AssumingTable1[Semana] is what you have in the rows of the visual shown:

```Measure =
SUMX (
DISTINCT ( Table1[Semana] ),
CALCULATE (
VALUES ( Scorecard[Puntos] ),
FILTER (
Scorecard,
[SalyTo19] >= Scorecard[Desde] && [SalyTo19] < Scorecard[Hasta]
)
)
)
```

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers

4 REPLIES 4
Super User

## Re: Total Value Columm Measure

AssumingTable1[Semana] is what you have in the rows of the visual shown:

```Measure =
SUMX (
DISTINCT ( Table1[Semana] ),
CALCULATE (
VALUES ( Scorecard[Puntos] ),
FILTER (
Scorecard,
[SalyTo19] >= Scorecard[Desde] && [SalyTo19] < Scorecard[Hasta]
)
)
)
```

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers

Highlighted
Regular Visitor

thanks!

Regular Visitor

## Re: Total Value Columm Measure

@AlB  hi, i just added the Month Row, so now i have Month and week but the month is not adding the amounts of each week subtotal,

any ideas?

Super User

## Re: Total Value Columm Measure

You need to add the month in the measure too:

```Measure =
SUMX (
SUMMARIZE ( Table1,Table1[Month], Table1[Semana] ),
CALCULATE (
VALUES ( Scorecard[Puntos] ),
FILTER (
Scorecard,
[SalyTo19] >= Scorecard[Desde] && [SalyTo19] < Scorecard[Hasta]
)
)
)```

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 45 members 891 guests
Recent signins: