Forum Discussion

robertosangi's avatar
robertosangi
Helper I
4 years ago
Solved

Filter one column count

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

Need Help
  • truptis's avatar
    truptis
    4 years ago

    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

1 Reply

  • truptis's avatar
    truptis
    Community Champion
    4 years ago

    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