Forum Discussion

Hell-1931's avatar
Hell-1931
Helper II
6 years ago

Filtering out negative values

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!

1 Reply

  • ChiaraB's avatar
    ChiaraB
    Frequent Visitor

    Hi,

     

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

     

    Chiara