Filtering out negative values

[Hell-1931]

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!

[ChiaraB]

Hi,

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

Chiara