Forum Discussion
Dax table does not display measure values
Hello, I have created a slicer, with which the user can enter the date of the document. Then the period is calculated with measure (Period = document date - 1 month (in format (yyyymm))).
My measures and tables for slicer and period:
Custom DocumentDate = CALENDAR(DATE(2022, 12, 1), TODAY()+160)
_Periode = IF(MONTH([_DocumentDate])=1,((YEAR([_DocumentDate])-1)*100) + (MONTH([_DocumentDate])+11), (YEAR([_DocumentDate])*100) + (MONTH([_DocumentDate])-1))
And it works in Visual but not in DAX table 😞 As you can see below, after adding column to the table, the lowest value is displayed and not the calculated one "202312".
Also with "_IsVissible = IF('Custom Diagramm'[Periodname]<=[_Periode],1,0)" it display only 0 because the input is "202211" and not "202312".
How can I improve my measurement so that the values calculated from the slican can also be seen in the table? I need it for visual filtering so, for example, in June, the data for the whole year will not be visible, but only until June.
Thank you for your help.
3 Replies
Hi Adrian, the problem is that slicer selections cannot be reflected in calculated columns
Calculated columns refresh and change their values once with the data model refreshI
think you can achieve the same output using an iterator function.
If You can send a sample report here with dummy data i might be able to help
Hi Khaled, thanks for your reply. I didn't know that about slicers.
So is there any way how can users insert data such as document date? It doesn't have to by throught a slicer, but it cannot be a SQL table.
if your goal is to filter the visuals, then use measures, not calculated columns, and then use those measures as filterson your visuals
