Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
expected outcome measure: =
COUNTROWS (
FILTER (
'Calendar',
'Calendar'[Date] >= MAX ( Employee[Joined Date] )
&& IF (
NOT ISBLANK ( MAX ( Employee[Relieving Date] ) ),
'Calendar'[Date] <= MAX ( Employee[Relieving Date] ),
MAX ( 'Calendar'[Date] )
)
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
In my table visual, I've noticed that the total of the measure is not appearing.This is concerning to me, as I intend to utilize this total value in a card visualization as well.
@Jihwan_Kim I would greatly appreciate it if you could spare some time to help me troubleshoot and rectify this situation.
And i am also going to calculate Last 12 months total sum for the above measure. Kinldy advise me whther the attached dax will work or not
Note - My my employee table and calendar tabale does not have any relationship.
Hi,
Please try the below in order to see the total row in the table visualization.
expected outcome measure: =
SUMX (
VALUES ( Employee[Employee] ),
CALCULATE (
COUNTROWS (
FILTER (
'Calendar',
'Calendar'[Date] >= MAX ( Employee[Joined Date] )
&& IF (
NOT ISBLANK ( MAX ( Employee[Relieving Date] ) ),
'Calendar'[Date] <= MAX ( Employee[Relieving Date] ),
MAX ( 'Calendar'[Date] )
)
)
)
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picture and the attached pbix file.
expected outcome measure: =
COUNTROWS (
FILTER (
'Calendar',
'Calendar'[Date] >= MAX ( Employee[Joined Date] )
&& IF (
NOT ISBLANK ( MAX ( Employee[Relieving Date] ) ),
'Calendar'[Date] <= MAX ( Employee[Relieving Date] ),
MAX ( 'Calendar'[Date] )
)
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
21 | |
20 | |
19 | |
13 | |
12 |
User | Count |
---|---|
42 | |
28 | |
23 | |
22 | |
22 |