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
Add support for identity columns in Fabric warehouses.
Identity columns are a common method for generating surrogate keys in data warehousing scenarios implemented on SQL Server. By adding support for identity columns in Fabric, users could migrate the...dpurdy4 hours agoRegular VisitorCompleted4.4KViews131likes11CommentsFabric 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_Ghafoor10 hours agoSuper UserNew6Views0likes0CommentsCopilot 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...dcohare10 hours agoHelper INew8Views1like0Comments