Forum Discussion

amsoares's avatar
amsoares
Regular Visitor
4 years ago
Solved

USING CONCATENATEX IN MULTIPLE SLICER SELECTION AND APPLY AS A CRITERIA FOR CALCULATION

I'm trying to implement a calculation based on as criteria defined by a slicer selection. I have a table with data similar to this one :   Capacity Offline Type 300 100 Planned 350 20...
Need Help
  • amsoares's avatar
    amsoares
    4 years ago

    I figured what was the problem , this works fine :

    Offline_Type =
    CALCULATE(
        SUM('public bi_final_timeseries'[offline_cap_offline]),
        'public bi_final_timeseries'[offline_outage_typ]
            IN ALLSELECTED(Outage_Type[Outage_Type])
    )
amsoares's avatar
amsoares
Regular Visitor
4 years ago

I figured what was the problem , this works fine :

Offline_Type =
CALCULATE(
    SUM('public bi_final_timeseries'[offline_cap_offline]),
    'public bi_final_timeseries'[offline_outage_typ]
        IN ALLSELECTED(Outage_Type[Outage_Type])
)