Question about filtering

alvayag

to show blank data i usually create an if isblank on my measure

for example

sales =
IF ( ISBLANK ( SUM ( table[values] ) ), 0, SUM ( table[values] ) )

this usually forces a 0 value when empty and will bring back the data for everything, but i m not sure if thats the best way to do.

Well, I feel like an idiot now.

Thinking about relations, the problem was the way my data was organized.

What I did was make another Excel file with a table containing a column with the names of the clients (no duplicates), then I made a relationship in Power BI and use this clients table as my filter.

Now it shows the data the way I want.

Thank you for all the trouble, vanessafvg!

alvayag

You can also create The Clients Table in DAX:

in Modeling-New Table

Clients=Distinct(TableName[ClientColumn])

and related.