Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

total value shouldnot get changed

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

 

 

2 ACCEPTED SOLUTIONS
tackytechtom
Super User
Super User

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/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

Arul
Super User
Super User

@RanjanThammaiah ,

try this measure for your sales,

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

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


View solution in original post

2 REPLIES 2
Arul
Super User
Super User

@RanjanThammaiah ,

try this measure for your sales,

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

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


tackytechtom
Super User
Super User

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/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Find out what's new and trending in the Fabric Community.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.