Sum error

Question

DaysAbove = what-if parameter&nbsp;I have a tabular table with Date and CountID and a DaysWhereFlag.&nbsp;(If the count of that ID goes over the 'DaysAbove')&nbsp;DaysWhereFlag = IF(COUNT(BedModelData[PatientMeditechID]) &gt; 'tbl_DaysAbove'[DaysAboveValue], 1, 0)&nbsp;The DaysWhereFlag has 1s or 0s in. The total is always 1 but would like to SUM the 1's.&nbsp;I have tried so many different ways, looked at many websites but just cannot get it to work.&nbsp;Any help will be greatly appreciated.&nbsp;

vanessafvg · Answer

are you able to provide some sampel data or your pbix?
&nbsp;
please also demonstrate an example of what you want to see.

anonymous · Answer

Hi&nbsp;Have you tried:Calculate(Sum(DaysWhereFlags),Filter(TableName,&nbsp;(BedModelData[PatientMeditechID]) &gt; ('tbl_DaysAbove'[DaysAboveValue]))

davidsimm10 · Answer

Thank you for the replies. The 'DaysWhereFlag' is a measure so it wont allow it to be put into the dax above.

anonymous · Answer

Hi,What i found here is you giving flag value in measure instead of generating the measure, Generate the same value in the Calculated column and then try same formula.I hope this will help you.Thanks.Gaurav Jangra

davidsimm10 · Answer

Thank you. When I turn it into a column, it just needs to say 1/0 or true/false for the DaysWhereFlagCol. If I click 'Dont summarise', it returns all '1's'. I need to find which days are above the 'Days where what if' parameter and then sum the number of days that this happens.&nbsp;

Forum Discussion

Sum error

8 Replies

Related content

Running sum

Filtering a Sum

SUM

Improper Sum with slicer

error message