Problem while comparing the date in different periods for pie chart

[saivina2920]

I am creating different measure like (<10 days, 10 to 20 Days and >20 Days).

While applying the meaasure in pie chart values, i am getting erroras mentioned below.

sample test .PBIX file attached.

https://1drv.ms/u/s!AiSRcgO5FUmN8SEmIwIM57N3eobB?e=JC5V2l 

[v-yiruan-msft · Accepted solution]

Hi @saivina2920 ,

As checked your sample pbix file, there are some syntax error in measure [10to20Days] and [LessThan10Days]. Please update them with the below formulas and check whether it can get the correct result:

Note: The part in red font is newly added.

10to20Days =
CALCULATE (
    DISTINCTCOUNT ( EMP_TABLE[EMP_NO] ),
    FILTER (
        EMP_TABLE,
        EMP_TABLE[EMP_RESIGN_DATE] >= EMP_TABLE[vCalDate20]
            && EMP_TABLE[EMP_RESIGN_DATE] <= EMP_TABLE[vCalDate10]
            && EMP_TABLE[EMP_STATUS] = "Working"
    )
)

LessThan10Days =

CALCULATE (

DISTINCTCOUNT ( EMP_TABLE[EMP_NO] ),

FILTER (

EMP_TABLE,

EMP_TABLE[EMP_RESIGN_DATE] >= EMP_TABLE[vCalDate10]

&& 'EMP_TABLE'[EMP_RESIGN_DATE] <= EMP_TABLE[vToday]

&& EMP_TABLE[EMP_STATUS] = "Working"

)

)

Best Regards

[saivina2920]

Thanks for your reply.

Is it possible to upload the attachment in the post iteself.

because, i don't find any attachment link in the tool bar. that's why i given one drive link.

same related post in another thread. can you pls. check with that and reply when you are free.

https://community.powerbi.com/t5/Desktop/How-to-count-user-input-along-with-blank-field-od-date-colu... 

[v-yiruan-msft]

Hi @saivina2920 ,

You can get the updated file from this link.

Best Regards