Filter one column count

[robertosangi]

Hello,

I have one question regarding filtering one column in PBI for having different results than another column. 

Here are the problem -> I have to measure how many documents are released during the week and the weekend. I have a table in which I evaluate the day of the week and in another column, I write "Weekend" or "Week" related to the value of the day number.

Now. In a table I put those value: 

The result is:

Actually I have the column ConsegnaWeekEnd as follow:

So, what I wanted is to filter the column PdL only per values of "Week" and the column PdLWE only per number of value of "Weekend"

Like filtering with a filter:

Column PdL = Distinct Count of Week

Column PdLWE = Distinct Count of Weekend

How can I do that?

Thank you

[truptis · Accepted solution]

Hi @robertosangi ,
Create new measures for PDL and PDLWE.
For PDL use this :
PDL= calculate(distinctcount(Columnname), filter(tablename, ConsegnaWeekEnd ="Week"))
For PDLWE use this:
PDLWE= calculate(distinctcount(Columnname), filter(tablename, ConsegnaWeekEnd ="Weekend"))

If this helps you then please mark it as a solution. Thanks.

Regards,

TruptiS