Need a fiter based on the measure output.

[Anonymous]

Need a fiter based on the measure output. Measure created for calculating cumulative balance. need to filter negative positive values.

Cumulative =

CALCULATE(SUM('DPO'[AMOUNT]),

FILTER(ALL('CALENDAR'[Date]),

'CALENDAR '[Date]<=MAX('CALENDAR'[Date])))

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards

Lucien

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download sample PBIX file

I'm not entirely sure what you are aiming for- always best to supply an example of your desired result.

But I think what you want is a slicer to only show positive or negative numbers?

You can create a column that classifies the number as Positive or Negative

PosNeg = IF('DPO'[Amount] < 0, "Negative", "Positive")

Then create a slicer from that column and show either Pos or Neg

Regards

Phil

[PhilipTreacy]

Hi @Anonymous 

Bit confusing. Do you want to filter negatve or positive values?

need to filter negative positive values.

regards

Phil

[Anonymous]

@PhilipTreacy  yes, need to filter negative positive values in the grid.