The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have the following sales order, each line is a product
when I try to create a visual with PGM (profit gross margin), I get this useless extra row just because PGM is 0.00. As you can see we do have products with sales tonnage and 0.00 margin, so I want to keep products with tonnage, but I want to remove the products with no tonnage
I tried to go to Query and filter by empty or blank rows, but when I go to query this is what I found.
0% is empty, so I cannt remove empty
and I cannot removed base on blank, because this option doesnt show up in the list below
Does anyone have a suggestion on how to handle this?
thank you
Gustavo
Solved! Go to Solution.
Create a measure for Total PGM that would be like this:
Total PGM = VAR TotalPGM = SUM(Data[PGM]) RETURN IF(TotalPGM = 0,BLANK(),TotalPGM)
If PGM is 0, it will return blank and not zero, and won't populate a visual.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCreate a measure for Total PGM that would be like this:
Total PGM = VAR TotalPGM = SUM(Data[PGM]) RETURN IF(TotalPGM = 0,BLANK(),TotalPGM)
If PGM is 0, it will return blank and not zero, and won't populate a visual.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reportingthank you
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |