Calculated table using a measure to calculate data based on a slicer .

Question

I created a measure to calculate an amount based on multiple conditions, including one that calculates the amount for a specific period using a date slicer. However, when I apply an additional slicer to filter data based on a specific value (for example, from the "Policy" dimension table), the measure returns a blank result. If I use the measure without any slicers on the dimension tables, the amount calculates correctly as shown in the images below.&nbsp;It seems like the problem is in the variable "Above Zero". Is there any solution for this. Thank you in advance.-------------OSAmountnot13 = &nbsp;VAR MAX_DATE = LASTDATE('Date'[Date])&nbsp;VAR AboveZero = SELECTCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'FACT',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'FACT'[CLAIM_ID],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Amount", SUM('FACT'[OS_AMOUNT])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'FACT',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'FACT'[UW_DATE] &lt;= MAX_DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'FACT',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'FACT'[OVERRIDE_STATUS] &lt;&gt; "13"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'FACT',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'FACT'[BENEFIT_TYPE] = 1&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; [Amount] &gt; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "CLM_ID", 'FACT'[CLAIM_ID]&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; VAR MED_os_not_13 = CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM('FACT'[os_amount]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'FACT'[UW_DATE] &lt;= MAX_DATE,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; REMOVEFILTERS('FACT'[UW_DATE]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOT ('FACT'[OVERRIDE_STATUS] = "13"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'FACT'[BENEFIT_TYPE] = 1,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'FACT'[CLAIM_ID] IN AboveZero&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MED_os_not_13-----------------&nbsp;&nbsp;

shashidhar · Answer

Try this&nbsp;OSAmountnot13 =VAR MAX_DATE = LASTDATE('Date'[Date])VAR AboveZero = SELECTCOLUMNS(FILTER(CALCULATETABLE(SUMMARIZE('FACT','FACT'[CLAIM_ID],"Amount", SUM('FACT'[OS_AMOUNT])),'FACT'[UW_DATE] &lt;= MAX_DATE,'FACT'[OVERRIDE_STATUS] &lt;&gt; "13",'FACT'[BENEFIT_TYPE] = 1),[Amount] &gt; 0),"CLM_ID", 'FACT'[CLAIM_ID])VAR MED_os_not_13 = CALCULATE(SUM('FACT'[os_amount]),'FACT'[UW_DATE] &lt;= MAX_DATE,'FACT'[OVERRIDE_STATUS] &lt;&gt; "13",'FACT'[BENEFIT_TYPE] = 1,'FACT'[CLAIM_ID] IN AboveZero,REMOVEFILTERS('FACT'[UW_DATE]), -- To avoid conflicts with date slicerREMOVEFILTERS('Policy') -- To handle slicer interaction)RETURNMED_os_not_13

anonymous · Answer

Hi Razan_Omoush&nbsp;,
Based on the description, None of your expressions involve the policy_no column in the slicer visual, is there a relationship between the policy table and the fact table? So, try to check the relationship and use ALLSELECTED to remove filter.
&nbsp;
Best Regards,
Wisdom Wu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

ashish_mathur · Answer

Hi,
Share some data to work with, explain the question and show the expected result.&nbsp; Share data in a format that can be pasted in an MS Excel file.

Forum Discussion

Calculated table using a measure to calculate data based on a slicer .

3 Replies

Related content

DAX Calculated Measure

MoM calculation

Calculation Help

DAX Measure for Ranking the valid rows and calculating the average rating

Calculate Tooltips