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 All, In the below measure the 4th and 5th lines when I put the number for the result it works but when it's a measure it's not working. It gives the result as blank.
BS Amount =
VAR CurrentItem =
SELECTEDVALUE ( Account_Setup1[Grouping Class] )
RETURN
SWITCH (
TRUE (),
CurrentItem = "Total Assets", [Total Assets],
CurrentItem = "Total Liabilities", [Total Liabilities],
CALCULATE ( [All Amount], Account_Setup1[Type] = "Balance Sheet" )
)
Hi @Anonymous ,
Try this
BS Amount =
VAR CurrentItem =
MAX ( Account_Setup1[Grouping Class] )
RETURN
SWITCH (
TRUE (),
CurrentItem = "Total Assets", [Total Assets],
CurrentItem = "Total Liabilities", [Total Liabilities],
CALCULATE (
[All Amount],
Account_Setup1[Type] = "Balance Sheet"
)
)
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
CurrentItem = "Total Assets", [Total Assets], CurrentItem = "Total Liabilities", [Total Liabilities],
These 2 lines are lines which has issues.
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |