March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi guys,
Could someone help me, please?
I would like to filter the following table:
I am using the following formula to return values that are different from '-9' or bigger then "0", but there is an error.
Which formula could I use?
Thanks,
Karina
Solved! Go to Solution.
Hello
Why not apply a simple criterion in the <>-9 filter panel.
Hi,
You could use this check measure:
___check = if ( COUNTROWS(FILTER('Table','Table'[id]<>-9 || 'Table'[id] >0))>0,1, BLANK())
as seen here:
Link to file.
Please mark as solution if so. Thumbs up for the effort are appreciated.
Kind regards,
Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
@stevedep I want to return the values, in the case of this example the number 4, 6, 7 and 8. All that contain -9 will not be presented in a visualization table for example
It's filtering the rows in the table, therefore you get the values you are looking for?
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Hello
Why not apply a simple criterion in the <>-9 filter panel.
VALUES() returns a table. You can't use CALCULATE with that - you would need to use CALCULATETABLE().
Both of these cannot be the final result of your measure - you need a single ("scalar") value.
What should the result of the measure be? A yes/no value?
@lbendlin I want to return the values, in the case of this example the number 4, 6, 7 and 8. All that contain -9 will not be presented in a visualization table for example.
Ah, I misread, it should be <> -9
In the measure definition that I shared. You should be good then since it will return the rows that meet the filter criteria. Pls take a look.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |