Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I'm trying to create a chart(but first im using a table visual to see my measures) that shows per month the value of my measure.
So far i got this, the problem is when i use my slicerto select for example 15/03/2021 that will filter all the MonthYear of 202103, and give me this 3 lines
total Valueleft:1.117.503
what i want is that the measure "Measure" be the sum of the "Valueleft" and when i select for example 08/03/2021 only show me this 2 lines(and the sum of only that 2 lines).
total Valueleft:1.067.503
PowerBi File
Solved! Go to Solution.
Hi, @Anonymous ;
You could create measure as follows:
Measure =
SUMX (
FILTER (
ALL ( Planilha1 ),
[DatePayment] <= MAX ( 'DCalendar'[Dates] )
&& EOMONTH ( [DatePayment], 0 ) = EOMONTH ( MAX ( 'DCalendar'[Dates] ), 0 )
),
[ValueLeft])
and then create a flag measure to show only the rows that meet the requirements in Visuals .
flag =
IF (
MAX ( [DatePayment] ) <= MAX ( 'DCalendar'[Dates] )
&& EOMONTH ( MAX ( [DatePayment] ), 0 ) = EOMONTH ( MAX ( 'DCalendar'[Dates] ), 0 ),
1)
and apply it into filter.
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous ;
You could create measure as follows:
Measure =
SUMX (
FILTER (
ALL ( Planilha1 ),
[DatePayment] <= MAX ( 'DCalendar'[Dates] )
&& EOMONTH ( [DatePayment], 0 ) = EOMONTH ( MAX ( 'DCalendar'[Dates] ), 0 )
),
[ValueLeft])
and then create a flag measure to show only the rows that meet the requirements in Visuals .
flag =
IF (
MAX ( [DatePayment] ) <= MAX ( 'DCalendar'[Dates] )
&& EOMONTH ( MAX ( [DatePayment] ), 0 ) = EOMONTH ( MAX ( 'DCalendar'[Dates] ), 0 ),
1)
and apply it into filter.
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
first of all, make sure your DatePayment is in DATE format, not in TEXT format.
if it is in date format, you can use following slicer to filter out data]
Unfortunately this doesn't work,cause the measure ValueLeft gets the wrong value
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |