Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
hello, I am very new to power bi and in dax language, I wanted to make a query with an example, the column "cto level of line" is a simple sum of a certain field, what formula can I occupy so that the result reaches only the column site?, in the example to the store there are values in negative and in postive, I would like that in each warehouse I brought the total of the site and for everyone showed the value 0 that is the result if we only saw up to the site.
Solved! Go to Solution.
Hi @Syndicate_Admin ,
You could try ISINSCOPE() or ISFILTERED() function.
https://docs.microsoft.com/en-us/dax/isinscope-function-dax
https://docs.microsoft.com/en-us/dax/isfiltered-function-dax
Then create a measure like below to return different value depend on the ISINSCOPE() result.
IF(ISINSCOPE([column]),[sum],0)
Best Regards,
Jay
Hi @Syndicate_Admin ,
You could try ISINSCOPE() or ISFILTERED() function.
https://docs.microsoft.com/en-us/dax/isinscope-function-dax
https://docs.microsoft.com/en-us/dax/isfiltered-function-dax
Then create a measure like below to return different value depend on the ISINSCOPE() result.
IF(ISINSCOPE([column]),[sum],0)
Best Regards,
Jay
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
106 | |
68 | |
48 | |
47 | |
47 |