Forum Discussion
Showing filter values
- 4 years ago
In DAX Studio, right click on the table you want to get filters for and choose "Define Filter Dump Measure". There's also an option to define it for all tables. You could edit that to only include the tables you are interested in.
In DAX Studio, right click on the table you want to get filters for and choose "Define Filter Dump Measure". There's also an option to define it for all tables. You could edit that to only include the tables you are interested in.
- doriel4 years agoRegular Visitor
Greetings johnt75 and thanks for your contribution.
The DAX Studio is an different application. I should create "Filter Dump measure" and then implement the code into Power BI? I use Power BI desktop application, downloaded DAX studio, opened my project and created dump filter query. What should I do next?
Should I copy the DAX source code into Power BI application? The output from DAX studion seems to be *.DAX file, I will try to import it to the Power BI somehow, but if you could give me another hint, I would be very very gratefull 😎
Sincerely yours,
Doriel.
- doriel4 years agoRegular Visitor
OK, I managed to put the DAX code into the measure column.
Now it shows filtered values. Thanks for directions, johnt75 !
But If I fliter date, it shows all filtered values. I filter relative date (lats 30 days for example) and the filter is not showing the lowes date, it shows all values (selected 305 items, for example).
How could I program the column, so it shows only the lowest date? Desired information would be "date: from --.--.---- to --.--.----"
Any idea, please?
- doriel4 years agoRegular Visitor
MIN function does the job 😄