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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
AlexaderMilland
Helper III
Helper III

ALL measure function not working

AlexaderMilland_1-1663586145575.png

 



Some background able to table:

 

The availability comes from a feed which only have rows for (8557-128) = 8429 SKUs. 
Which is merged on the product table with 25000+ SKUs inside Power Query. 
The null values are then replaced with "Ukendt". 
This is all inside Power Query, so the final ProductTable just contains flat rows with the values. There is only 1 active table in question here. 

On the page filter I've removed certain old SKUs so we are left with a total of 8557 SKUs. 

The measures above is then from a different data set using direct query to the PBI file which has the above data. 

Why is the calculation extremely inaccurate when selecting "Ukendt"? I cannot even grasp where it gets the 657 number from. I need it to say 8557 regardless of the selection 🙂 

Am I missing some logic with null values? I thought it wouldn't filter backwards on a table that is merged in Power Query. Shouldn't the table contain the flat information?  

2 REPLIES 2
amitchandak
Super User
Super User

@AlexaderMilland , All Product availability only remove filter from that column. Other column filter will remain

 

You can try all(Product )

 

or all()

 

and check

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

That gives me all the 25000+ SKU's as it removes my filters to get down to the 8557. It does however give me the same result regardless of what [Availability] field i pick. So I guess i need to cleanse another filter somewhere that is tied together with the Availability?

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.