Forum Discussion

saivina2920's avatar
saivina2920
Post Prodigy
5 years ago
Solved

count data mismatching in Table Chart

I am getting some wrong count in the chart table. Example, i have given the below.    sample Test File and data Link : https://1drv.ms/u/s!AiSRcgO5FUmN8USBS75RKolqBQDT?e=HBxCu6    What is t...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi saivina2920 ，

    Please update the formula of measure [TempBalCount] as below and check whether it can get your expected result.... You can find the attachment for the details. 

    TempBalCount =
    VAR _selreldate =
    SELECTEDVALUE ( EMP_TABLE[EMP_RESIGN_DATE] )
    RETURN
    IF (
    ISFILTERED ( 'EMP_TABLE'[EMP_STATE] ),
    IF (
    [XTOY] = [YTOX],
    BLANK (),
    IF ( _selreldate > [vToday], 0, [XTOY] - [YTOX] )
    ),
    BLANK ()
    )

    Also, it is worth noting that if you want to implement this "dynamic" feature it is not appropriate to get the duration days by creating a calculated column [DurDays]. So you have to use the measure [Duration days] instead of the calculated column [DurDays]. For more information about the difference between calculated columns and measure, you can read the following blogs.

    Calculated Columns and Measures in DAX

    Calculated Columns vs Measures

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi saivina2920 ,

Please update the formula of measure [TempBalCount] as below:

TempBalCount =
VAR _selreldate =
SELECTEDVALUE ( EMP_TABLE[EMP_RESIGN_DATE] )
RETURN
IF (
[XTOY] - [YTOX] = 0,
BLANK (),
IF ( _selreldate > [vToday], 0, [XTOY] - [YTOX] )
)

Best Regards

saivina2920's avatar
saivina2920
Post Prodigy
5 years ago

awesome results.

In the below screenshot, when user selects "EMP_STATE" then only it should show the records in the table. otherwise no need to display records in the table.

How to apply this logic..?

 

If this works, then mine is over.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi saivina2920 ，

    Please update the formula of measure [TempBalCount] as below and check whether it can get your expected result.... You can find the attachment for the details. 

    TempBalCount =
    VAR _selreldate =
    SELECTEDVALUE ( EMP_TABLE[EMP_RESIGN_DATE] )
    RETURN
    IF (
    ISFILTERED ( 'EMP_TABLE'[EMP_STATE] ),
    IF (
    [XTOY] = [YTOX],
    BLANK (),
    IF ( _selreldate > [vToday], 0, [XTOY] - [YTOX] )
    ),
    BLANK ()
    )

    Also, it is worth noting that if you want to implement this "dynamic" feature it is not appropriate to get the duration days by creating a calculated column [DurDays]. So you have to use the measure [Duration days] instead of the calculated column [DurDays]. For more information about the difference between calculated columns and measure, you can read the following blogs.

    Calculated Columns and Measures in DAX

    Calculated Columns vs Measures

    Best Regards

  • saivina2920's avatar
    saivina2920
    Post Prodigy
    5 years ago

    It's Awesome and it's fantastic logic with favourable reply.