Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Consider an Excel blank sheet where cell A1 = 12, and we define a condition for cell B1 =IF(A1>10,"Cell is greater than 10", "Cell is less than 10"). Result for cell B1 = Cell is greater than 10.
How do I achieve this on Power BI, in a simple table format just like in Excel, preferably multiple lines with conditions and results like the above.
Solved! Go to Solution.
Hi @bmk ,
I created a sample pbix file(see attachment), please check whether that is what you want.
Create a measure or calculated column as below to get the status text:
Measure =
VAR _curvalue =
SELECTEDVALUE ( 'Table'[A] )
RETURN
IF (
_curvalue > 10,
"Cell is greater than 10",
IF ( _curvalue < 10, "Cell is less than 10", "Cell is equal to 10" )
)
Column =
SWITCH (
TRUE (),
'Table'[A] > 10, "Cell is greater than 10",
'Table'[A] < 10, "Cell is less than 10",
"Cell is equal to 10"
)
Best Regards
Thank you!
@bmk with DAX measuere
Measure = switch (true(), calculate(max(fact[colA]))>10, "Cell is greater than 10","Cell is lesser than 10")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |