Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Count the Result Measure to Create Bar Chart

Hi,   We have data like bleow where Accrual Booked, Actual Work Accrual Value of Work, Accural Calculated and Result are measures created on fronend,  and Work Unit and FE Class are table column. ...
General Comment
Need Help
Tips and Tricks
dharmendars007's avatar
dharmendars007
Icon for Memorable Member rankMemorable Member
2 years ago

Hello Anonymous , 

 

I created 2 simple measures where for both "Pass and Fail",  you can create Bar chart with this by adding them to x axis..

Pass = CALCULATE(

       COUNT('Table'[Work Unit]), 'Table'[Result] = "Pass")
Fail = CALCULATE(
            COUNT('Table'[Work Unit]), 'Table'[Result] = "Fail")

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

 

Thank You

Dharmendar S

LinkedIN 



Anonymous's avatar
Anonymous
Not applicable
2 years ago

I tried using above measure that is giving the different count than the data in table visual.

  • dharmendars007's avatar
    dharmendars007
    Icon for Memorable Member rankMemorable Member
    2 years ago

    Are you looking to have only distinct count of work unit if so you can replace count by distint count.

     

    If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

     

    Thank You

    Dharmendar S

    LinkedIN 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Even if I use the distinct count it is giving the same result as using count and not matching with the expected results

      • dharmendars007's avatar
        dharmendars007
        Icon for Memorable Member rankMemorable Member
        2 years ago

        share us the sample dataset with the expected result and wrong result this will help us to check further...