Blanks wanted

[MansRydell]

Hi All

I´m trying to get measure below to only show values for columns Uppgift and År Månad(from date table).

Budgeterad kostnad =

SUMX (

'Fördelningsnyckel',

VAR __h =

CALCULATE ( SUM('Fördelningsnyckel'[Budget]))

RETURN

__h

)

Using this I get this:

What I´m after is that the values in the red box are Blank.

Tables:
Fact_Hours

Date------------	Uppgift-	Namn-	Anteckningar
20220121	1	Bob	Hi
20220112	1	Lisa	Ho
20220104	2	Boris	Hi

Dim_date date relation one way to hours date

Date_____________	År Månad
20220101	2022 Januari
20220102	2022 Januari
etc	etc

Dim_Fördelningsnykel Avdelning bidirectional relation to Hours Uppgift 

Avdelning---	Budget
1	100000
2	200000

Any idees?

[v-jayw-msft · Accepted solution]

Hi @MansRydell ，

You could use ISINSCOPE() or ISFILTER() function.

For example:

Measure = IF(ISINSCOPE('Table'[Namn]),BLANK(),[Budgeterad kostnad])

Result would be shown like below.

Best Regards,

Jay

[v-jayw-msft · Accepted solution]

Hi @MansRydell ，

You could use ISINSCOPE() or ISFILTER() function.

For example:

Measure = IF(ISINSCOPE('Table'[Namn]),BLANK(),[Budgeterad kostnad])

Result would be shown like below.

Best Regards,

Jay

[MansRydell · Accepted solution]

@v-jayw-msft Awsome!! that did it : ) thanks a bunch Buddy

/Måns

[amitchandak]

@MansRydell ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.