The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
i have a table with transaction, volume, stream (Digital, Manual, intermidate)
i have dax to show percentage of each. but i mainly want to focus on digital.
My matrix table shows transaction, and digital percent.
when i drill through to transaction detail, the digital percent is alway 100 percent. it does not seem to be taking into account the other stream volumes Digital, Manual, intermidate)
% Digital =
VAR Total = sum('FACT - Transactions'[Volume])
VAR Digital = [Digital Volume]
Return
DIVIDE(Digital,Total,"-")
Solved! Go to Solution.
Hey @NewbieJono ,
For getting the "Total" to be used as a denominator in the DIVIDE dax, you would need to use ALL in order to remove the filters applied. You can try:
var Total = Calculate(Sum('FACT - Transactions'[Volume]),ALL(Stream[ColumnName]))
Hey @NewbieJono ,
For getting the "Total" to be used as a denominator in the DIVIDE dax, you would need to use ALL in order to remove the filters applied. You can try:
var Total = Calculate(Sum('FACT - Transactions'[Volume]),ALL(Stream[ColumnName]))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
112 | |
69 | |
48 | |
43 |
User | Count |
---|---|
188 | |
87 | |
77 | |
74 | |
60 |