Help with DAX Measure

Question

Hello everybody,&nbsp;i am try to setup a measure that sums up the amount of GL_ENTRY under specific conditions.&nbsp;Tha values should only be taken into consideration for the shortcutdimension 6 when the shortcutdimension 3 is empty.&nbsp;Otherwise some values&nbsp;are counted twice which should not be the case. I tried this measure.I also tried with&nbsp;'G_L Entry'[ShortcutDimension Code 3] = BLANK()and&nbsp;ISBLANK('G_L Entry'[ShortcutDimension Code 3] but the values where&nbsp;'G_L Entry'[ShortcutDimension Code 3]&nbsp;is not empty alsways get taken into the calculation.GLAmount3 =IF(&nbsp; &nbsp; Projekt_Dimensionswerte[Postenart] = "GL_Entry",&nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; SUM('G_L Entry'[Amount]),&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'G_L Entry',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'G_L Entry'[G_L Account No_] &gt;= "4000" &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'G_L Entry'[G_L Account No_] &lt;= "7999" &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CONCATENATE(MONTH('G_L Entry'[Posting Date]), YEAR('G_L Entry'[Posting Date])) = CONCATENATE(MONTH(Projekt_Dimensionswerte[Datum]), YEAR(Projekt_Dimensionswerte[Datum])) &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'G_L Entry'[ShortcutDimension Code 6] = Projekt_Dimensionswerte[ID] &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'G_L Entry'[ShortcutDimension Code 6] &gt;= "60100" &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'G_L Entry'[ShortcutDimension Code 6] &lt;= "60200" &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'G_L Entry'[ShortcutDimension Code 3] = ""&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'G_L Entry'[ShortcutDimension Code 3] = Projekt_Dimensionswerte[ID] &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'G_L Entry'[ShortcutDimension Code 3] &gt;= "7000" &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'G_L Entry'[ShortcutDimension Code 3] &lt;= "7030"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ))Does someone know what I am doing wrong?Aprreciate your help

benjaminblume10 · Accepted Answer

never mind&nbsp;it works nad i am just a little bit blind in the morning

Forum Discussion

Help with DAX Measure

2 Replies

Related content

Measure

DAX Measure

Path Measure

% of total measure

Count Measure