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 Experts
I cannot see what i am doing wrong here this should be stright forward calcultion in DAX...
See Screem iamge i am trying to add only the Total Rev PY number if they are postive and ignore blank cell like Jan and Feb as shown...
The filter is on dimension Divestiture and month and year and YTD..... but cannot get the dax to give the right output...
% Organic Test 3 = IF(CALCULATE([Total Revenue PY], FILTER(Profitability,Profitability[Divestiture]="Divestiture"))=BLANK(),BLANK(),CALCULATE([Total Revenue PY], FILTER(Profitability,Profitability[Divestiture]="Divestiture")))
Solved! Go to Solution.
Hi @Anonymous
Can you show the code for your [Total Revenue PY]? In fact sharing the pbix would be best
Isn't your code for [% Organic Test 3] exactly the same as:
% Organic Test 3 V2 = CALCULATE ( [Total Revenue PY], FILTER ( Profitability, Profitability[Divestiture] = "Divestiture" ) )
Hi @Anonymous
Can you show the code for your [Total Revenue PY]? In fact sharing the pbix would be best
Isn't your code for [% Organic Test 3] exactly the same as:
% Organic Test 3 V2 = CALCULATE ( [Total Revenue PY], FILTER ( Profitability, Profitability[Divestiture] = "Divestiture" ) )
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |