Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count unknown data with date possible?

Hi Power Community! so this shows the "known" data and "unknown" data (data with no delivery date or forwarder). So far so good.    Now I have a date slicer. If you use the date slicer it fo...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    According to my understanding, you want to display total/known/unknown data based on date slicer, right?

    You could try this:

    Total = COUNTROWS('Table') 
    Known Data =
COUNTROWS (
    FILTER (
        'Table',
        'Table'[DeliveryDate] <> BLANK ()
            && 'Table'[Forwarder] <> BLANK ()
    )
) + 0

     The final output looks like this:

    Please kindly check my pbix file here.

     

    Best Regards,
    Eyelyn Qin

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

According to my understanding, you want to display total/known/unknown data based on date slicer, right?

You could try this:

Total = COUNTROWS('Table') 
Known Data =
COUNTROWS (
    FILTER (
        'Table',
        'Table'[DeliveryDate] <> BLANK ()
            && 'Table'[Forwarder] <> BLANK ()
    )
) + 0

 The final output looks like this:

Please kindly check my pbix file here.

 

Best Regards,
Eyelyn Qin

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous Excuse me. I had no time in the holiday season...

    Thank you for your time - it worked perfectly ğŸ˜Š