Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
29 | |
14 | |
11 | |
10 | |
9 |