Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I'm facing a mismatch between values due my calculation DAX formula.
I have a dataset below and I need to count the subjects by fiscal month and return a percentage of this subjects by fiscal month. For the table the result is OK, but for chart the return is only 100%.
The dataset:
Fiscal_Year | Fiscal_Month | Subject_Title | Evaluation |
FYear20 | FMonth11 | Algebra I | Good |
FYear20 | FMonth11 | Algebra II | Bad |
FYear20 | FMonth11 | Algebra III | Bad |
FYear20 | FMonth12 | Statistic | Neutral |
FYear21 | FMonth01 | Social Science | Bad |
FYear21 | FMonth01 | Algorithms | Good
|
I used both calculation DAX formulas:
The result work fine for table, but not for the chart:
Does anyone knows how to plot the same result from column "Second Calculation" in this chart? I'm sure that the problem is related to my DAX formula, but I'm trying to use the Fiscal Month as the ALL filter without success.
Solved! Go to Solution.
@Ito_c , as per your given data I have created % Eva Measure based on Fiscal Month.
@Ito_c , Which chart are you using? MAke sure you are using Stack Column Chart instead of 100% Stack Column Chart.
Hi @Tahreem24, using a stack I have something like:
But the disered result is the sum of column "Second Calculation" by Evaluation by Fiscal Month:
@Ito_c, Is it possible for you to share the similar data by masking confidential data so that I will try at my end.
Hi @Tahreem24 , sorry I clicked as a solved. My dataset is the same in the description (I have 4 columns by 6 rows):
Fiscal_Year | Fiscal_Month | Subject_Title | Evaluation |
FYear20 | FMonth11 | Algebra I | Good |
FYear20 | FMonth11 | Algebra II | Bad |
FYear20 | FMonth11 | Algebra III | Bad |
FYear20 | FMonth12 | Statistic | Neutral |
FYear21 | FMonth01 | Social Science | Bad |
FYear21 | FMonth01 | Algorithms | Good |
@Ito_c , as per your given data I have created % Eva Measure based on Fiscal Month.
Thank you @Tahreem24 , I understood the point to use fiscal month not only in the filter, but the count of variable "a" must be the month count too.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |