Forum Discussion

jimrosser's avatar
jimrosser
Icon for Helper III rankHelper III
1 year ago
Solved

If selected value is All Formula

Hi I"m trying to create a measure based on two measures when the selected value is = "ALL" or <> "ALL" Below is the measure I've been working with but it won't calculate.  Any helps is much apprecia...
Need Help
  • Deku's avatar
    Deku
    1 year ago

    If date table is filtered return the all measure else the year measure

    IF (
    not ISCROSSFILTER(vwPBIDate[Fiscal Month Number]),
    calculate( [Bud_Sales_Rev_ALL]),
    calculate( [Bud_Sales_YEAR]) 
)

     

Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

If date table is filtered return the all measure else the year measure

IF (
    not ISCROSSFILTER(vwPBIDate[Fiscal Month Number]),
    calculate( [Bud_Sales_Rev_ALL]),
    calculate( [Bud_Sales_YEAR]) 
)

 

jimrosser's avatar
jimrosser
Icon for Helper III rankHelper III
1 year ago

Thanks Deku - I did have to change the ISCROSSFILTER to ISCROSSFILTERED but it worked, Thank you very much!