Forum Discussion
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
- ChiaraBFrequent 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