Forum Discussion
adrianpro
2 years agoFrequent Visitor
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 ...
khaledHabib90
2 years agoResolver II
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
adrianpro
2 years agoFrequent Visitor
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.
- khaledHabib902 years agoResolver II
if your goal is to filter the visuals, then use measures, not calculated columns, and then use those measures as filterson your visuals