bug
3 TopicsWorking with DATATBALE in Query View! Is this some kind of bug or am I doing something wrong?
I was playing around with the Query View in Power BI Desktop. I wanted to create a table from scratch without importing from any source and then I wanted to show output of the table also perform some calculations on it later. I thought of using Table Constructor first but as it doesn't allow to give names to the columns directly so I used DATATABLE instead. I tried to run this query in the Query View: DEFINE VAR Sample_Table = DATATABLE( "First Name",STRING, "Last Name",STRING, "Time",DATETIME, { {"Reza","Rad",0}, {"Leila","Etaati",}, {"someone",,"2019-2-10"}, {"Unknown",blank(),"2019-2-10"} } ) EVALUATE EVALUATEANDLOG(Sample_Table) Then I got the error: "DAX Evaluate queries work only on databases which have at least one tables." Now after searching on google and asking copilot, I didn't get anything relevant to this. Then finally I decided to make a Calculated Table and as usual it worked and I could perform all the operations. Now I tried once again to debug the previous code. So I deleted that Caluclated Table and then ran the query, that I've provided above, in the Query View. To my surprise, the query ran and gave the output. I thought it maybe because of cache so I canged the values in DATATABLE and again the query gave output with changed values. To summarize this, I am providing the recording of the same. Please tell if this is some kind of bug or is there something wrong with the code. Link to VideoSolved1.3KViews0likes4CommentsCalculated Column not being executed
Hello! I have a table called Progression1 with a calculated column generated with the following code: Rate= CALCULATE(sum(Masterfile1[Awarded]),Masterfile1[STATUS]="GRD",Progression1[Term])/42.34) It works perfectly, and it creates a column with the values that I need. However, when I try to replicate in my second table called Progression2, like this: Rate= CALCULATE(sum(Masterfile2[Awarded]),Masterfile2[STATUS]="GRD",Progression2[Term])/42.34) Nothing happens. I don't get the usual loading screen and seems like the code is not being executed at all. If I click anything afterwards the calculated column goes back to the default Column = Anyone has any idea why does this happens? Is it something on my end? Thank you!692Views0likes3CommentsSelectedValue DAX formula not behaving as described in documentation
I've experienced a sudden change in the behavior of the SELECTEDVALUE() formula. It used to have the value of the row you selected in a table, but now returns BLANK(). You can see my measure SelectedValueUPCTest =: SELECTEDVALUE('Retail Item'[UPC]), and due to the context it should show the same as the 'Retail Item'[UPC] column for every row in this table but instead returns Blank(). Any ideas?Solved882Views0likes1Comment