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