Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 Unit | FE Class | Accrual Booked | Actual Work Accrual | Value of Work | Accrual Calculated | Result |
301600 | 105 | 273.24 | 979.75 | 568.63 | 243.19 | Pass |
306993 | 105 | 436.6 | 919.45 | 355.57 | 500.85 | Fail |
307820 | 105 | 718.84 | 343.5 | 951.73 | 985.49 | Pass |
308291 | 105 | 534.79 | 195.62 | 396.75 | 461.87 | Fail |
308429 | 105 | 588.93 | 540.06 | 278.7 | 788.87 | Pass |
308961 | 110 | 682.56 | 827.43 | 717.94 | 455.23 | Pass |
308962 | 110 | 303.39 | 558.82 | 292.06 | 966.26 | Fail |
309165 | 205 | 775.87 | 856.5 | 975.73 | 976.75 | Pass |
309355 | 105 | 473.51 | 376.9 | 707.35 | 289.37 | Pass |
309357 | 105 | 718.09 | 105.72 | 516.78 | 542.13 | Fail |
309404 | 110 | 738.12 | 929.66 | 235.01 | 523.45 | Pass |
309633 | 110 | 657.6 | 318.92 | 437.16 | 701.22 | Fail |
309696 | 105 | 326.00 | 336.73 | 573.86 | 735.23 | Pass |
309834 | 105 | 652.22 | 479.43 | 749.98 | 841.46 | Pass |
309883 | 105 | 896.75 | 995.59 | 437.5 | 830.61 | Fail |
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:
Please let me know if you are having any questions.
Thanks,
Bhimashankar
Hello @Bhimashankar_Dc ,
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(
If you find this helpful , please mark it as solution and Your Kudos are much appreciated!
Thank You
Dharmendar S
I tried using above measure that is giving the different count than the data in table visual.
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
Even if I use the distinct count it is giving the same result as using count and not matching with the expected results
share us the sample dataset with the expected result and wrong result this will help us to check further...
You can refer to data given in first post, that is data and we are using live connection that time count DAX is not working expected.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
108 | |
108 | |
93 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |