Need Help

[santhoshacc]

Hi,

Please help me with dax for below requirement.

I need to create one measure, and also two slicers, now that measure value should not change based on the one slicer value out of two slicer.

Can I use the allexcept function.

Thanks,
Santhosh.

[v-lili6-msft]

hi, @santhoshacc

You could use ALL Function in your formula.

and here is a blog about Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT

By the way, you could share your sample pbix file or some data sample and expected output. and we could help you to create the measure. Do mask sensitive data before uploading.

Best Regards,

Lin

[ryan_mayu]

@santhoshacc

In the Edit Interaciton, you can break the link with measure and slicer. Hope this is helpful. Thanks

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers