Hi AllI´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_HoursDate------------Uppgift-Namn-Anteckningar202201211BobHi202201121LisaHo202201042BorisHi Dim_date date relation one way to hours dateDate_____________År Månad202201012022 Januari202201022022 Januarietcetc Dim_Fördelningsnykel Avdelning bidirectional relation to Hours Uppgift Avdelning---Budget11000002200000 Any idees?

Anonymous Awsome!! that did it : ) thanks a bunch Buddy/Måns

Anonymous

Not applicable

4 years ago

Solved

Blanks wanted

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

Dim_date date relation one way to hours date

Dim_Fördelningsnykel Avdelning bidirectional relation to Hours Uppgift

Any idees?

Anonymous
4 years ago
Hi Anonymous ，

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
Anonymous
4 years ago
Anonymous Awsome!! that did it : ) thanks a bunch Buddy

/Måns