Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
69 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |