Back

Explore Courses Blog Tutorials Interview Questions

Power BI, filter taking into account multiple columns

0 votes
2 views
in BI by (11.1k points)
I want a filter which has a combined value of two columns and  I would like to add a row in my visualization and two values are greater than 1

How can i solve this

1 Answer

0 votes
by (22.5k points)

Check this DAX formula

greaterThan1 = IF(Table1[ValueA]>=1,TRUE(),if(Table1[ValueB]>=1,TRUE(),FALSE()))

If you want to learn more about Power BI, then read the Power BI Tutorial. Also, enroll in Power BI Training to become proficient in this BI tool.       

Related questions

0 votes
1 answer
Power BI Filter By Multiple Criteria using “AND”
asked Feb 21, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
Power BI Dataset(or few columns) into Power Apps
asked Jan 2, 2021 in BI by Vamsee Krishna (22.5k points)
0 votes
1 answer
Power BI Dataflow access network restricted Azure Storage Account
asked Feb 15, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
Power bi box and whisker: filter with an if statement
asked Mar 28, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
How to turn the drillthrough filter off in a single visual in Power BI?
asked Feb 28, 2021 in BI by Chris (11.1k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...