Forum Discussion
Create Measure to calculate Net impact on filtered value
Hi Jodes007 ,
Sorry, not very clear.
If you want to filter out rows NET impact<0 in the visual. In the Filters, set up as follows.
If you want to filter out NET impact<0 in the measure.
COUNT TOTAL = CALCULATE(COUNT('Table'[ProgramID]),FILTER(ALLSELECTED('Table'),[Total Impact]>=0))COUNT GROUP BY ProgramID = CALCULATE(COUNT('Table'[ProgramID]),FILTER(ALLSELECTED('Table'),[ProgramID]=MAX('Table'[ProgramID])&&[Total Impact]>=0))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jodes007 ,
Sorry, not very clear.
If you want to filter out rows NET impact<0 in the visual. In the Filters, set up as follows.
If you want to filter out NET impact<0 in the measure.
COUNT TOTAL = CALCULATE(COUNT('Table'[ProgramID]),FILTER(ALLSELECTED('Table'),[Total Impact]>=0))COUNT GROUP BY ProgramID = CALCULATE(COUNT('Table'[ProgramID]),FILTER(ALLSELECTED('Table'),[ProgramID]=MAX('Table'[ProgramID])&&[Total Impact]>=0))
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry, it should have read NET impact >0. Filtering does not work as the Total impact is at the Application level where there are many lines. BUT the count group looks like it makes sense. I will try it today and see.
Hi Jodes007 ,
Is your problem solved?
If so, please accept the reply as solution. More people will benefit.
If not, please provide me with more details about it.
Best Regards,
Stephen Tao