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.
I have some graphics that as the filter made the values of these graphs is blank or infinite, and according to the business rule that can happen but I need to make when this happens does not show anything, no value should be displayed, is possible to do that?
@vitexo87 for all Measures that give you BLANK() in Cards do the following...
= IF ( ISBLANK ( [Expression]), 0, [Expression] )
@vitexo87 infinity happens when you divide by zero so instead of / use the DIVIDE function
= DIVIDE( [Numerator], [Denominator], 0)
tried to use the DIVIDE function in my measure however is not working
% Target Revenue Surplus = (DIVIDE (CALCULATE (SUM (Facts [Vl_Suplementado]) * 100; Facts [OrigemRecurso_DS] = "Surplus Financial") / sum (Facts [Vl_ReceitaPrevista])) / 100); 0)
@vitexo87 Try this...
% Target Revenue Surplus = DIVIDE ( CALCULATE ( SUM ( Facts[Vl_Suplementado] ) * 100; Facts[OrigemRecurso_DS] = "Surplus Financial" ); DIVIDE ( SUM ( Facts[Vl_ReceitaPrevista] ); 100; 0 ); 0 )
works however when the numeric value is represented is bringing more decimal places
with a filter
without filter
@vitexo87 Try this... let me know if this works
% Target Revenue Surplus = DIVIDE ( CALCULATE ( SUM ( Facts[Vl_Suplementado] ); Facts[OrigemRecurso_DS] = "Surplus Financial" ); SUM ( Facts[Vl_ReceitaPrevista] ); 0 )
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |