Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
When I am trying to calculate a new measure in PowerBI, it doesn’t pop up the results for already available columns in Dataset instead it only pops up the suggestion for the measure which I calculated earlier. Please note that I have tried re-installing and repairing PowerBI but it's not working. The app is updated to June 2023 version. The columns are not hidden either. M intellisense is enabled also. Please advise what is going wrong here. It was working fine earlier and suddenly it stopped showing the suggestions of columns while creating a new measure
I look forward to the solution.
Hello @Raghuvanshi ,
Not all dax fuctions can use columns, some of them can just work with measures. To check if things are working fine, try the dax funvtion COUNT(<column>) and it should allow you to reference a column.
learn about count https://learn.microsoft.com/en-us/dax/count-function-dax
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
@Idrissshatila Thank you for your reply.
I would like to give you additional information of the problem which I am facing. I am not talking something specifically about using COUNT function. Here is the screenshot for your reference
While creating measure, i only get the calculated measure for the reference. This file has API integration with our tool and I am working on static data. The dataset has many columns but none of the column pops up while i start writing measure.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |