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.
Hello Power BI community
I Need to build a measure that can calculate 100% based on all categories for each month. I want to apply this measure to my visualized Stacked column Chart. (I know I can use a 100 % Stacked column chart to show the correct percentage) But I only want to show this measure in my tooltips and keep the original visualization.
This is my Dax code so far:
Solved! Go to Solution.
Hi @Anonymous ,
You can update the formula of measure [Percentage] as below:
Note: please update the name of date field with the correct one in the table SALESFORCE_CASES_FCT_20210429 .
Percentage = DIVIDE ( [Total cases], CALCULATE ( [Total cases], FILTER ( ALLSELECTED ( 'SALESFORCE_CASES_FCT_20210429' ), FORMAT ( 'SALESFORCE_CASES_FCT_20210429'[Date], "YYYY-MM" ) = SELECTEDVALUE ( 'DIM_DATE'[YYYY-MM] ) ) ), 0 ) |
Best Regards
Hi @_Rena
thanks you for your help.
I don't know why but Its also works when I tried with All function.
@Anonymous , I think it should be the only case Origin in all except
Percentage = DIVIDE([Total cases],CALCULATE([Total cases],ALLEXCEPT(SALESFORCE_CASES_FCT_20210429, SALESFORCE_CASES_FCT_20210429[CASE_ORIGIN (groups)])),0)
Hello amitchandak thanks for the answer.
However, I still experienced the issue. Example, Its give me percentage of 4,41 % when it should be 40,74 %
Hi @Anonymous ,
You can update the formula of measure [Percentage] as below:
Note: please update the name of date field with the correct one in the table SALESFORCE_CASES_FCT_20210429 .
Percentage = DIVIDE ( [Total cases], CALCULATE ( [Total cases], FILTER ( ALLSELECTED ( 'SALESFORCE_CASES_FCT_20210429' ), FORMAT ( 'SALESFORCE_CASES_FCT_20210429'[Date], "YYYY-MM" ) = SELECTEDVALUE ( 'DIM_DATE'[YYYY-MM] ) ) ), 0 ) |
Best Regards
Hi @_Rena
thanks you for your help.
I don't know why but Its also works when I tried with All function.
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |