Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Kim_Sky
Helper II
Helper II

greater than

Hi, 

It might be an easy question but I can't figure out the correct method. 

I have a category list 

Category Sub
A1
A2
B3
B4
 
 

 

TimestampValueSub
5/6/2022401
5/6/20221003
5/6/2022503
 

 

I would like to calculate true or false (if 3 value larger than 60 then true, less than 60 then false ; if 1 value larger than 50 then true, less than 50 then false)

 
I'm try using code below. 
 

Total value

3= CALCULATE( NOT ISEMPTY(Total value),Total value[Value] >60 )

 

Thanks for your help. 

6 REPLIES 6
PabloDeheza
Solution Sage
Solution Sage

Hi there!

You could try something like this:

SWITCH(

TRUE(),

Sub = 3 && Value > 60, TRUE,

Sub = 3 && Value <= 60, FALSE,

Sub = 1 && Value > 50, TRUE,

Sub = 1 && Value <= 50, FALSE,

BLANK()

)

Let me know if that help!

 

Hi @PabloDeheza , 

There shown error in this code. 

Kim_Sky_0-1660740643404.png

FYI, this are my two table. 

 

Kim_Sky_1-1660740662790.png

Kim_Sky_2-1660740670633.png

Thanks for your help. 

 

Make sure to refer to the corresponding column and table, I used sub and value as an example, but it would be 'Total Value'[Sub] and 'Total Value'[Value] instead of just "Sub" and "Value". Also make sure you create this calculated column in Total Value table

Hi @PabloDeheza

However, I have a list of the value 

TimestampValueSub
5/6/2251
5/6/22431
5/6/22201
5/6/2262

 

I wish to get the sum from sub 1 and the value if >50 then true, sub 2>20 then true

 

So it will be telling me true for 1 because is 68 while false for 2 <20. 

Are there any method to do this? 

 

Thanks for your help. 

Hi @PabloDeheza

Is create a new column or use new measure? 

That way would be for a calculated column

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.