Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Fix blank values and infinite

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 any...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Sean

works however when the numeric value is represented is bringing more decimal places

 

with a filter

 

without filter

 

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

Anonymous 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
)