Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to count 2 condition?

Now I count status Date = 2021 04 01 but I want to count status Date = 2021 04 01  and status = Complete I have DAX as below. Count of Implement Status Date = VAR __CurrentMeasure = CALCULATE( ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    I am not sure how your data type in your pbix file looks like, but I think you need to have a date-type column in the table.

    Please check the below pbix file's link.

     

     

    https://www.dropbox.com/s/xbgle5ipajq5i83/adamasmay.pbix?dl=0 

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Yes, please share your excel file with mentioning how you want to show in visual, for instance, table visual or bar chart, or any others.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Jihwan_Kim v-luwang-msft  file excel example : file excel input 

I want to count status (2021) = Complete and status date = april 2021

 

I want to show amount count in card visual.

Please guide me about it.

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Anonymous 

    I am not sure how your data type in your pbix file looks like, but I think you need to have a date-type column in the table.

    Please check the below pbix file's link.

     

     

    https://www.dropbox.com/s/xbgle5ipajq5i83/adamasmay.pbix?dl=0 

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM