Forum Discussion

dandamudisanjay's avatar
dandamudisanjay
Regular Visitor
5 years ago

Help with DAX

Hi Experts,    Hope you all are doing well.    I'm hoping to get some help with the following issue.    We have two tables, table 1 and table 2 connected with 1-N relation  with fields as below...
@Dax
@dax @help
SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
5 years ago

dandamudisanjay, Is your requirement to count the number of KPIs by User?

  • dandamudisanjay's avatar
    dandamudisanjay
    Regular Visitor
    5 years ago

    Hi SivaMani ,

     

    I'm looking to get total of ID's from table 1 which meets the following conditions. 

     

     

    - if KPI = "Target1" then count of ID's where category is "category 1"

    - if KPI = "Target2" then count of ID's where category is "category 2"

    - else, total count of ID's