Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Team,
I have dax like.
Hi @amitchandak ,
Please find the sample data.
Keyword | Revenue | Source |
ab | 3072.301 | A |
cd | 536.0652 | A |
avd | 829.9001 | B |
sef | 970.6752 | B |
srfd | 1351.724 | B |
ssww | 2676.865 | C |
fgg | 938.9079 | C |
treaq | 7.315659 | E |
awrdew | 2.699883 | F |
rt4dsa | 350.427 | F |
AWEWSA | 3.079823 | F |
SAFGERQA | 1.594021 | D |
EWFRGEQE | 2.123724 | D |
EWFREWDWQ | 3.431873 | D |
45EGTVDSEW | 1.897625 | D |
FRW | 11.6391 | D |
EWGEW | 12.37913 | D |
Thanks,
Arvind
@Arvind123 , You might have used GT for total revenue column
Either try this way (two measures)
M1 = SUMX(
FILTER(allselected('BT3 Keyword'), 'BT3 Keyword'[Keyword] = Max('BT3 Keyword'[Keyword])),
'BT3 Keyword'[Total revenue]
)
Filtered Revenue > 500 =
if(not(isinscope('BT3 Keyword'[Source])),
SUMX(FILTER(
VALUES('BT3 Keyword'[Keyword]),
[M1]> 500
),'BT3 Keyword'[Total revenue]), [M1])
Or (two measures)
M1 = SUM(
'BT3 Keyword'[Total revenue]
)
Filtered Revenue > 500 =
if(not(isinscope('BT3 Keyword'[Source])),
SUMX(FILTER(
VALUES('BT3 Keyword'[Keyword]),
[M1]> 500
),calculate(sum('BT3 Keyword'[Total revenue]))), [M1])
Hi @amitchandak ,
Thanks for your quick response!
Here by using your 2nd measure I am getting value of source, But It is also giving me value of those keywords whose total revenue after summing of all source revenue is not greater than 500 also.
I dont want those keywords whose revenue is less than 500.
for your reference this keywords should not be there by condition and by using your dax
the total value is showing blank for those keyword whose revemue is less than 500 where as if total is greater than 500 it is sowing in column total.
Regards,
Arvind
@Arvind123 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Team,
@Anonymous
@community24
@Community2
Can I get modified dax ..
@amitchandakhas provided me the dax like:
M1 = SUM(
'BT3 Keyword'[Total revenue]
)
Filtered Revenue > 500 =
if(not(isinscope('BT3 Keyword'[Source])),
SUMX(FILTER(
VALUES('BT3 Keyword'[Keyword]),
[M1]> 500
),calculate(sum('BT3 Keyword'[Total revenue]))), [M1])
This dax gives me right indication but it is also showing all the keyword who has not surpass the value 500.
The value who has achieved 500 more that gives me in total value for that particular keyword and who has not greater than 500 that shows me blank... So that blank value I don't want in my table.
Thanks,
Arvind
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
145 | |
73 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |