Results 1 to 2 of 2

Thread: Need a Power bi Dax function to giving missing data in related table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2008
    Posts
    84
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need a Power bi Dax function to giving missing data in related table

    Hi All,
    I HAVE 2 tables.
    Table 1: CMDB
    Table 2: CPUutilization report

    Table 1 is static report with list of unique Server name
    Table 2 consist of data for entire month with date, Server name and it's Avg utilisation % for each day.

    The issue is Table 2 will have some Servers missing on daily basis.

    My requirement is to get the list of Servers from CMDB missing in Table 2 for particular date Selected.

    Kindly do the needful.

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,189
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need a Power bi Dax function to giving missing data in related table

    Write this measure
    Count of missing servers =countrows(filter(cmdb,calculate(countrows(table2))=0))

    pit the server names on rows in a matrix/pivot and the measure in values.
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •