Calculate Measure not working for one but working for rest.

[Anonymous]

This is the code for
Measure for 1 WEEK "Upto 1 Week = CALCULATE([Total Open Invoices], 'Invoicing WF Details'[DELAY (DAYS)] <= 7)" NOT WORKING

Measure for 2 WEEK "Upto 2 Weeks = CALCULATE([Total Open Invoices], 'Invoicing WF Details'[DELAY (DAYS)]>7, 'Invoicing WF Details'[DELAY (DAYS)]<=14)" Working!!
Measure for delay above 3 months "Delay Over 3 Months = CALCULATE([Total Open Invoices],'Invoicing WF Details'[DELAY (DAYS)] >= 120)" Working

[Anonymous · Accepted solution]

Hi，@Anonymous 

According to the sample you provided, we found that there are blank values in it, which may be the reason why your Measure for 1 WEEK "Upto 1 Week does not work.

You can create a new measure to solve it:

Measure = CALCULATE(COUNT('Invoicing WF Details'[Delay(Days)]),FILTER(ALL('Invoicing WF Details'),'Invoicing WF Details'[Delay(Days)]<=7&& ISNUMBER('Invoicing WF Details'[Delay(Days)])))

Then you can meet your needs like this：

 

Here is the demo, please try it: https://qiuyunus-my.sharepoint.com/:u:/g/personal/admin_qiuyunus_onmicrosoft_com/EWth-UGf5btJpzrHsSszeawBe_A7e3DyxT6zBN7QHffjwQ?e=QujukE

Hope it helps.

Best Regards,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi，@Anonymous 

According to the sample you provided, we found that there are blank values in it, which may be the reason why your Measure for 1 WEEK "Upto 1 Week does not work.

You can create a new measure to solve it:

Measure = CALCULATE(COUNT('Invoicing WF Details'[Delay(Days)]),FILTER(ALL('Invoicing WF Details'),'Invoicing WF Details'[Delay(Days)]<=7&& ISNUMBER('Invoicing WF Details'[Delay(Days)])))

Then you can meet your needs like this：

 

Here is the demo, please try it: https://qiuyunus-my.sharepoint.com/:u:/g/personal/admin_qiuyunus_onmicrosoft_com/EWth-UGf5btJpzrHsSszeawBe_A7e3DyxT6zBN7QHffjwQ?e=QujukE

Hope it helps.

Best Regards,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Appreciate the reply and help. But, I want the count of unique "Workflow ID" for who's delay days is less than 7 days.

[Anonymous · Accepted solution]

Hi, @Anonymous 

please try the measure below to see the count of unique "Workflow ID" for who's delay days is less than 7 days.

Measure  = 
VAR _table=CALCULATETABLE(VALUES('Invoicing WF Details'[Workflow ID]),FILTER(ALL('Invoicing WF Details'),'Invoicing WF Details'[Delay(Days)]<7&& ISNUMBER('Invoicing WF Details'[Delay(Days)])))
Return
COUNTROWS(_table)

Hope it helps.

Best Regards,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Is DELAY (DAYS) is a measure or column. 

Try like

CALCULATE([Total Open Invoices],filter( 'Invoicing WF Details', 'Invoicing WF Details'[DELAY (DAYS)] <= 7))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Delay Days is a Column. 
I tried CALCULATE([Total Open Invoices],filter( 'Invoicing WF Details', 'Invoicing WF Details'[DELAY (DAYS)] <= 7)) as well.

[Anonymous]

Shows up like this

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.