SUM OF FILTERED VALUES

Question

Hello everyone. I want to add a conditional with the following:

If the BDPE code is greater than 30, 30 days will be subtracted, otherwise it will be 0. I think I could have had the conditional but when I make the total sum it comes out the same as measure 2.

I want to find the correct sum for VACTRUN

I put the formulas I could create

Measure 2 = CALCULATE(SUMX(NOMINATION,NOMINATION[Imp Valor]),FILTER(NOMINATION,NOMINATION[CODE. NOW]="BDPE"))

VACTRUN = IF([Measure 2]>30,[Measure 2]-30,0)

I hope for your support please.

I copy the drive with the pbix for more visualization
https://drive.google.com/file/d/1bU2qGu0gg7bq-pUG5NX2WuyePkTvQZT2/view?usp=sharing

vojtechsima · Answer

Hello,&nbsp;Syndicate_Admin&nbsp;,I'll assume you that you want to compare It on "CONCAT" column level present in the table:
&nbsp;
New Measure = SUMX(VALUES(NOMINA[CONCAT]), [VACTRUN] )
&nbsp;

&nbsp;

v-sdhruv · Answer

Hi&nbsp;Syndicate_Admin&nbsp;,
Just wanted to follow up if you have tried implementing the solution above.If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.Thanks

v-sdhruv · Answer

Hi&nbsp;@Syndicate_Admin&nbsp;,Just wanted to follow up if you have tried implementing the solution above.If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.Thanks

v-sdhruv · Answer

Hi&nbsp;@Syndicate_Admin&nbsp;,Just wanted to follow up if you have tried implementing the solution above.If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.Thanks

Forum Discussion

SUM OF FILTERED VALUES

4 Replies

Related content

Filtering a Sum

SUM for Filtered Values

Negative values not be summed correctly

Filter and Sum

SUM OF FILTERED VALUES