display all status but complete status should include value of Approaching Expiry and Expired

[ganes]

display all status but complete status should include value of Approaching Expiry and Expired

I need complete count to be 147(complete + Approaching Expiry + Expired) How to do that

[Anonymous · Accepted solution]

Hi, @ganes 

According to your description, you want to generate more rows in the visual, however, according to the calculation rules, you must have 147 rows in the table (complete + Approaching Expiry + Expired), which is not realistic and is not supported in the logic of the table and in the current version of Power BI. You can use a card to display the total value or use the Summarize function to implement a virtual table, as shown below:
1.Use Card

SumValue =
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER (
        'Table',
        'Table'[Status] = "Complete"
            || 'Table'[Status] = "Appproching Expiry"
            || 'Table'[Status] = "Expired"
    )
)

2. Use Summarize function

Table 2 =
SUMMARIZE (
    'Table',
    "SumCompleteandApprochingExpiryandExpired",
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER (
                'Table',
                'Table'[Status] = "Complete"
                    || 'Table'[Status] = "Appproching Expiry"
                    || 'Table'[Status] = "Expired"
            )
        ),
    "Complete",
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER ( 'Table', 'Table'[Status] = "Complete" )
        ),
    "Request Cancelled",
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER ( 'Table', 'Table'[Status] = "Request Cancelled" )
        ),
    "Appproching Expiry",
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER ( 'Table', 'Table'[Status] = "Appproching Expiry" )
        ),
    "Expired",
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER ( 'Table', 'Table'[Status] = "Expired" )
        )
)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Gabry]

It depends on how is arranged your model, you can do this with a calculated column.

show the measure used. Anyway this could be the formula:

IF(SELECTEDVALUE([status])="complete", CALCULATE(SUM([numbers]), [status]="complete" || [status]="expired" || [status]="Approaching"),SUM([number]))