total value shouldnot get changed

[RanjanThammaiah]

Hi all,

I know this is simple, I have a sales value that has to be filtered only when there is a filter applied to Region attributes.

And any other filters applied should not get changed, I cannot use the Edit interaction because I need the value for the corresponding calculations.

Regards,

Ranjan

[tackytechtom · Accepted solution]

Hi @RanjanThammaiah ,

Have you tried it with using the ISFILTERED function?

ISFILTERED function (DAX) - DAX | Microsoft Learn

It could be something like:

IF ( ISFILTERED ('Region'), [SalesMeasure], CALCULATE ( [SalesMeasure], ALL ( 'Region' ) )

Does this work? Let me know 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Arul · Accepted solution]

@RanjanThammaiah ,

try this measure for your sales,

Sales for region = 
CALCULATE(
    SUM(financials[ Sales]),
    ALLEXCEPT(financials,financials[Country]))

Thanks,

Arul

[tackytechtom · Accepted solution]

Hi @RanjanThammaiah ,

Have you tried it with using the ISFILTERED function?

ISFILTERED function (DAX) - DAX | Microsoft Learn

It could be something like:

IF ( ISFILTERED ('Region'), [SalesMeasure], CALCULATE ( [SalesMeasure], ALL ( 'Region' ) )

Does this work? Let me know 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/