Forum Discussion

Noob_with_PBI's avatar
Noob_with_PBI
Regular Visitor
3 years ago
Solved

Help with visualization

Hello All,   I am new and learning PowerBI, and have been stuck with something and i hope someone may be able to shine a light 🙂   I have a table that has a list of customers and several columns...
Need Help
  • vicky_'s avatar
    vicky_
    3 years ago

    This depends on the structure of your data. If you had a table with the items that have been purchased, and a list of all items, you could do something like:

    CALCULATE(
    COUNTROWS(
        EXCEPT(SELECTCOLUMNS([all_items]), SELECTCOLUMNS([purchased_items])
    )
)

    (note: i haven't tested this code) But the idea is that you want to get all of items that haven't been purchased and then ignore all of the ones that have been purchased. Here's the docs on the EXCEPT function: https://learn.microsoft.com/en-us/dax/except-function-dax

vicky_'s avatar
vicky_
Super User
3 years ago

This depends on the structure of your data. If you had a table with the items that have been purchased, and a list of all items, you could do something like:

CALCULATE(
    COUNTROWS(
        EXCEPT(SELECTCOLUMNS([all_items]), SELECTCOLUMNS([purchased_items])
    )
)

(note: i haven't tested this code) But the idea is that you want to get all of items that haven't been purchased and then ignore all of the ones that have been purchased. Here's the docs on the EXCEPT function: https://learn.microsoft.com/en-us/dax/except-function-dax