cancel
Showing results 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

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 A 1 A 2 B 3 B 4

 Timestamp Value Sub 5/6/2022 40 1 5/6/2022 100 3 5/6/2022 50 3

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 )

6 REPLIES 6
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!

Helper II

Hi @PabloDeheza ,

There shown error in this code.

FYI, this are my two table.

Solution Sage

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

Helper II

Hi @PabloDeheza

However, I have a list of the value

 Timestamp Value Sub 5/6/22 5 1 5/6/22 43 1 5/6/22 20 1 5/6/22 6 2

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?

Helper II

Hi @PabloDeheza

Is create a new column or use new measure?

Solution Sage

That way would be for a calculated column

Announcements

#### 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 Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors