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 duri...
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

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