hi

Question

hi&nbsp;i have a single table&nbsp; when i filter by&nbsp;dont starts with CRonly invoice date 01-01-2024 to 01-01-2024 (one day)&nbsp;and net_amt &gt;= 4000 then i see in power bi table or data menu tab which is on second on left side 165 data and this 165 is same with mssql query&nbsp;&nbsp;but by&nbsp; using measure formula&nbsp;CALCULATE (&nbsp; &nbsp; COUNT('bm_retail_t ssummary'[INVOICE_NO]),&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; VALUES ( 'bm_retail_t ssummary'[INVOICE_NO] ),&nbsp; &nbsp; &nbsp; &nbsp; NOT ( LEFT ( 'bm_retail_t ssummary'[INVOICE_NO], 2 ) = "CR" )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM ( 'bm_retail_t ssummary'[NET_AMT] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLEXCEPT (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'bm_retail_t ssummary',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'bm_retail_t ssummary'[INVOICE_NO],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'bm_retail_t ssummary'[STORE_CODE]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) &gt;= 4000&nbsp; &nbsp; ))&nbsp;in power bi visual i see 621 in total .&nbsp;can some one help me out as this is same table and there are no relation with other table in measure calculaiton&nbsp;i want to have 165 output from single table measure formaula count of invoice number&nbsp;&nbsp;&nbsp; there are few blank which are less than 4000 and this is fine. dont worrry about followings&nbsp;&nbsp;thanks&nbsp;

abc_777 · Accepted Answer

need calcuative column not measure. thx i solved it myself

Forum Discussion

hi

1 Reply