Hi: Need help with the below Power BI dashboard issue Issue: In the dashboard I am displaying data in tabular form. But it’s not aggregating the data (key figures) based on the key (dimensions) value. Here is the example I have the below 6 rows in my output Column1---Column2---Column3---Column4 ABC---INDIA---RED---4 ABC---INDIA---GREEN---6 ABC---INDIA---GREEN---2 XYZ---INDIA---RED---5 XYZ---INDIA---RED---8 XYZ---INDIA---RED---2 The desired output to show in the dashboard is like below ABC---INDIA---RED---4 ABC---INDIA---GREEN---8 XYZ---INDIA---RED---15 Basically numeric values need to be aggregated to the Char Key values. It’s not working for me. Am I missing any setting??? If you can help me technically to fix this, I am willing to pay for your time. Please contact me at [email protected]
3 Comments
- H0wl12New MemberIs column 4 set to Sum in aggregation?
- chass
Impactful Individual
Hello, Unfortunately this forum is for filing bugs. Luckily Marco has an example very similar here: https://social.msdn.microsoft.com/Forums/sharepoint/en-US/ae8973ad-b066-419b-90f3-11e7f225331e/equivalent-of-tsqls-if-exists-in-dax?forum=sqlanalysisservices Thanks, Chuck - fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
Fabric UX Idea: Clearly Identify the Source Workspace for Opened Fabric Artifacts
In many Fabric implementations, organizations have multiple projects and environments, for example: Sales Analytics – Development Sales Analytics – UAT Sales Analytics – Production Similarl...Murtaza_Ghafoor3 hours agoSuper UserNew5Views0likes0CommentsCopilot in Power BI should be canvas-aware and support screenshots / direct visual debugging.
Currently, Copilot in Power BI cannot: See the actual canvas / selected visual Accept screenshots or images to aid in troubleshooting Both of these make debugging visual-level issues painful and...dcohare3 hours agoHelper INew7Views1like0Comments