Forum Discussion
date and time intelligence; evaluation by rows
Hey guys, need your help please.
You have on your left 3 graphs that are affected by a left date slicer
You have on the righ 2 graphs that are affected by a right date slicer
The issue is that on the left you see that in my table negative values appears but on the right side i have the same table without negative values. The one difference between two tables is a time period that i defined.
I want to calculate the number of days between two dates. For instance : my first first column date in Accident table is 1 april 2018 and the second date in my second column date in Accident is 1 mai 2018, then i will define my period time using a slicer ( lets take 2 april 2018 and 30 april 2018). According to my criterias defined in a measure i will have 30 april 2018-2 april 2018= to count the number of days.
For sure the problem is with blanks in my Accident table, i tried to isolate that in my measure but it seems to be slightly effective
Can somebody help me with that. Thanks a lot
HI Anonymous,
It is impossible to use a measure to get different selection results from the same data source slicers. (you will get same values from these slicers) Please create other tables as the source of slicers, then you can use Dax formulas to extract values from selections.
Regards,
Xiaoxin Sheng
5 Replies
why most of relationships are inactive ?
What is this formula doing?
Hi Anonymous,
Can you please share some dummy data with the same data structure to help us clarify your scenario?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Yes, sorry
Here is a link to a new simplified file - https://easyupload.io/7t6rq8HI Anonymous,
It is impossible to use a measure to get different selection results from the same data source slicers. (you will get same values from these slicers) Please create other tables as the source of slicers, then you can use Dax formulas to extract values from selections.
Regards,
Xiaoxin Sheng
