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 guys,
Based on this picture, If I selected the Brand1 will apply to this formula, but I want the first I select is going to the first formula, secondly select will go to the second formula. How should I do? Is that possible to do this? Actually, this formula is not the actual formula this is the just simple formula I just want to ask how to fill only. How can help me? Is that clear my question?
Many = 1) CALCULATE(SUM(Data[Price]),FILTER(Data,Data[Brand]=VALUEs(Brand[Brand1]))) + 2) CALCULATE(SUM(Data[Price]),FILTER(Data,Data[Brand]=VALUEs(Brand[Brand1])))
Solved! Go to Solution.
Hi AlbisLoke,
PBI can’t recognize which item is the first selected item in a slicer. As a workaround, if you want to sum up Data[Price] only based on rows in filter, you can simply use DAX formula:
Many = CALCULATE(SUM(Data[Price]), FILTER(Data, Data[Brand] = “AFFLIGEM”)) + CALCULATE(SUM(Data[Price]), FILTER(Data, Data[Brand] = “ANCHOR SD”))
if you want to sum up Data[Price] based on all of the selected item in slicer. you can use DAX formula below:
Many = IF(ISFILTERED(Brand[Brand1]), CALCULATE(SUM(Data[Price]), ALLSELECTED(Brand[Brand1])), BLANK())
PBIX file here:
https://www.dropbox.com/s/ntc2fr33rs8i2lt/For%20AlbisLoke.pbix?dl=0
Regards,
Jimmy Tao
Hi AlbisLoke,
PBI can’t recognize which item is the first selected item in a slicer. As a workaround, if you want to sum up Data[Price] only based on rows in filter, you can simply use DAX formula:
Many = CALCULATE(SUM(Data[Price]), FILTER(Data, Data[Brand] = “AFFLIGEM”)) + CALCULATE(SUM(Data[Price]), FILTER(Data, Data[Brand] = “ANCHOR SD”))
if you want to sum up Data[Price] based on all of the selected item in slicer. you can use DAX formula below:
Many = IF(ISFILTERED(Brand[Brand1]), CALCULATE(SUM(Data[Price]), ALLSELECTED(Brand[Brand1])), BLANK())
PBIX file here:
https://www.dropbox.com/s/ntc2fr33rs8i2lt/For%20AlbisLoke.pbix?dl=0
Regards,
Jimmy Tao
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |