Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Power BI team,
I have some problem of my DAX formula and hope you can shed some light.
BACKGROUND:
When I select all the value in Sector slicer, all the reporting view show the correct calculation. Meaning the pie chart shown the breakdown of the status during the past 12 months correctly, the bar shown the breakdown of the 172 status fall across individual month correctly, the individual sectors percentage shown the correct figure (i.e. the 172 status sit in each of he sectors, finally the two detail traction tables showing the right figure and number of rows. So everything is fine as of now. But, .......
PROBLEMS:
But when I select a particular sector value in the Sector slicer, for example, I select "Resources" sector, there will be two problems arised:
Note: if I make 2 selections or 3 selections in the Sector slicer, I will hits the Problem 1 and Problem 2. But if select all the value in Sector slicer, no problems like that will happen. Please scroll down to see my Dax code.
MY DAX FORMULA:
All the individual Sector % calculation has it own Measure (coding is similar in each sector object) and divided by a denominator Measure.
<Denominator> -
Hope you can let me know what are going wrong with Problem 1 (DAX related) and Problem 2 (which I just drag the fields into the table, but it seems not correspond to the slicer).
Thanks.
Tuff
Solved! Go to Solution.
@Anonymous ,
Generally, you may add a FILTER() statement in the Nomibator measure and check if this issue persists:
MeasureTransport = CALCULATE ( COUNTROWS ( 'Asssessment_Action_20190219' ), DATESINPERIOD ( 'Asssessment_Action_20190219'[Last Assessment Date1].[Date], TODAY (), -13, MONTH ), FILTER ( ALLEXCEPT ( 'Asssessment_Action_20190219', 'Asssessment_Action_20190219'[Sector] ), 'Asssessment_Action_20190219'[Sector] = "TRANSPORT" ) ) / [MeasureTotal]
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
Generally, you may add a FILTER() statement in the Nomibator measure and check if this issue persists:
MeasureTransport = CALCULATE ( COUNTROWS ( 'Asssessment_Action_20190219' ), DATESINPERIOD ( 'Asssessment_Action_20190219'[Last Assessment Date1].[Date], TODAY (), -13, MONTH ), FILTER ( ALLEXCEPT ( 'Asssessment_Action_20190219', 'Asssessment_Action_20190219'[Sector] ), 'Asssessment_Action_20190219'[Sector] = "TRANSPORT" ) ) / [MeasureTotal]
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
102 | |
93 | |
73 | |
60 | |
59 |