Filtering out negative values

Hell-1931 — Fri, 10 Jan 2020 07:25:53 GMT

Hello,

In my SSAS tabular model I have the following measures, (which then used in Power BI Report):

% of Budget Used:=1.0 - DIVIDE(([Total Budget] - [Total Amount]), [Total Budget], BLANK())

% of Budget Used - consists from the followings:

Total Budget:=CALCULATE( SUM( 'GL Transactions'[Budget Amount] ), 'Calendar FY'[Date] )

Total Amount:= SUM( 'GL Transactions'[Amount])

After exporting these in Power BI Model, my report has the following result:

Are there ways to filter out the negative(s) values (marked in red)? My goal is to have blank, when it's negative...

I thought of using IsInScope function, but it isn't available in my current SSAS tabuler

May be I need to use IsFiltered instead? How exactly?

Thanks for help!

Re: Filtering out negative values

ChiaraB — Thu, 13 Apr 2023 14:15:03 GMT

Hi,

you could use conditional formatting on color of that field and set that if the value is negative then color is white!

Chiara