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.

 

Work UnitFE ClassAccrual BookedActual Work AccrualValue of WorkAccrual CalculatedResult
301600105273.24979.75568.63243.19Pass
306993105436.6919.45355.57500.85Fail
307820105718.84343.5951.73985.49Pass
308291105534.79195.62396.75461.87Fail
308429105588.93540.06278.7788.87Pass
308961110682.56827.43717.94455.23Pass
308962110303.39558.82292.06966.26Fail
309165205775.87856.5975.73976.75Pass
309355105473.51376.9707.35289.37Pass
309357105718.09105.72516.78542.13Fail
309404110738.12929.66235.01523.45Pass
309633110657.6318.92437.16701.22Fail
309696105326.00336.73573.86735.23Pass
309834105652.22479.43749.98841.46Pass
309883105896.75995.59437.5830.61Fail


Now here we want to create the bar chart based on Result with bars of counts of pass and fail. Can anyone please help me with DAX query that will count the pass and fail and we create bar chart out of it. I tried different DAX query but when the same data is taken into table visual the counts were not matching.

 

Data Fact:

  1. Work Unit will be unique
  2. We have one table with only one column having the value {"Pass" and "Fail"}, this we can use on X-axis for bar charts.

Please let me know if you are having any questions.


Thanks,
Bhimashankar

General Comment
Need Help
Tips and Tricks

6 Replies

  • 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