Colectables by date reporting

[LucasValiante77]

I'm having a trouble with my visualization on powerbi desktop,

I created a dashboard on customer debts, with the aim of monitoring customer debts, and I created metrics to organize debts into columns 0-30 days | 30-60 days | 60-120 days|

When I generate the table view, the line does not respect the order of the columns and simply adds up all the values

formulas below: 

Difference Days =

VAR DataAtual = MAX('LU DATA'[Data])

RETURN

CALCULATE(DATEDIFF( MAX('TBL Divida Clientes'[DataVencimento]),DataAtual, DAY), CROSSFILTER('LU Data'[Data],'TBL Divida Clientes'[DataRegisto],none))

01 - 30 Days =

if([Difference Days]>=01 && [Difference Days]<=30, [Dívida Pendente Moeda Original], blank())

It was supposed to show like this:
 

How it's right now:   

I can only see it organized when I add the document data to the line, but this is unfeasible as there are clients with +100 documents: 

I aprecciate if anyone can help me, thanks 🙂

[Anonymous]

Hi @LucasValiante77 

What is the DAX code for [Dívida Pendente Moeda Original]?

01 - 30 Days =
if([Difference Days]>=01 && [Difference Days]<=30, [Dívida Pendente Moeda Original], blank())

Please provide sample data that fully covers your question and describe the efforts you have already made in this table visual.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...