Forum Discussion

patrickbrooks13's avatar
patrickbrooks13
Frequent Visitor
1 year ago
Solved

KPI Card visual showing wrong value when 'Select All' is used

I have a kpi card showing Secured and Potential Revenue by Month and Financial year, however when All is selected in Month slicer and Financial year slicer, the value is wrong it seems to be just sho...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    Hi patrickbrooks13 ,

    Thank you for raising this issue in the community.

     

    I have reproduced your scenario in Power BI Desktop and I’m happy to confirm that I was able to achieve the expected KPI card visual output when “Select All” is used in both Month and FinancialYear slicers.

    What I did:

    • Created a KPI visual for Secured Revenue and another for Potential Revenue
    • Built custom DAX measures using ALLSELECTED() to ensure totals across all selected months and years
    • Connected both visuals to a proper DateTable
    • Enabled “Select All” in the slicers

    Result:

    • Total Secured Revenue: 11,800
    • Total Potential Revenue: 13,300
      (as expected, summing all selected months and years)

    To help you further, I’m attaching the .pbix file used for testing this scenario.
    Feel free to download it and adapt it to your data model.

     

    If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.


    Thank you.

mdaatifraza5556's avatar
mdaatifraza5556
Super User
1 year ago

Hi patrickbrooks13 

Can you please provide what DAX you are writing to get your result?

If you are not using the below dax, please try it once.

        Total Secured Revenue:=
                                  CALCULATE(
                                            SUM('RevenueTable'[SecuredRevenue]),
                                            ALLSELECTED('Date'[Month], 'Date'[FinancialYear])
                                   )


If this answers your questions, kindly accept it as a solution and give a kudos

patrickbrooks13's avatar
patrickbrooks13
Frequent Visitor
1 year ago

Hi, this is here. I have a target value in as well so it will go green if met and red if not met etc. 

KPI_Value =
VAR AllYears = ALL('FinancialYearTable'[FinancialYear])

-- Check if all years are selected in the slicer
VAR IsAllYearsSelected =
    COUNTROWS(VALUES('FinancialYearTable'[FinancialYear])) = COUNTROWS(AllYears)

-- Total secured amount (ALL years)
VAR TotalSecuredAmountAllYears =
    CALCULATE(
        SUM('Estimating PipelineAnalysis'[Amount]),
        FILTER(
            ALL('Estimating PipelineAnalysis'),
            'Estimating PipelineAnalysis'[Status] = "Secured"
        )
    )

-- Target for all years
VAR SecuredTargetAllYears =
    CALCULATE(
        SUM('EstTarget_Budget_Summary'[TotalAmount]),
        USERELATIONSHIP('EstTarget_Budget_Summary'[FinancialYear], 'FinancialYearTable'[FinancialYear]),
        FILTER(
            ALL('Estimating PipelineAnalysis'),
            'Estimating PipelineAnalysis'[Status] = "Secured"
        )
    )

-- Filtered secured amount (based on slicer)
VAR FilteredSecuredAmount =
    CALCULATE(
        SUM('Estimating PipelineAnalysis'[Amount]),
        'Estimating PipelineAnalysis'[Status] = "Secured"
    )

-- Filtered target (based on slicer)
VAR FilteredSecuredTarget =
    CALCULATE(
        SUM('EstTarget_Budget_Summary'[TotalAmount]),
        USERELATIONSHIP('EstTarget_Budget_Summary'[FinancialYear], 'FinancialYearTable'[FinancialYear]),
        'Estimating PipelineAnalysis'[Status] = "Secured"
    )

-- ✅ Return blank if all years selected, otherwise return calculated KPI
RETURN
IF(
    IsAllYearsSelected,
    BLANK(),
    FilteredSecuredAmount + FilteredSecuredTarget
)