Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a simple table
A matrix with a slicer shows:
But on the 20 January it shows only male:
But i like to see it with "F" column with 0 values. How can i do that?
Solved! Go to Solution.
Just wrap it around the main expression:
YTD = TOTALYTD(
IF(ISBLANK(SUM('Sheet1'[Value]),0,SUM(Sheet2[Value]))
,'Sheet1'[Date].[Date]
,'Sheet1'[Date]<= SELECTEDVALUE(Sheet1[Date])
)
Try this: CLick on the matrix. Click on the V next to fields you want to show
I did:
But the result is same.
Then you have two options. Separate the Sex column into its own dimension:
Or fill in the missing entries with Zeros
I split into separate Dimension and it works:
Matrix Settings:
Well.. doesn't show a 0... just blank.
Be sure to mark as solution if this provided the answer.
Thanks @Data-estDog . But on YTD shows no value for F.
YTD = TOTALYTD(SUM('Sheet1'[Value]), 'Sheet1'[Date].[Date], 'Sheet1'[Date]<= SELECTEDVALUE(Sheet1[Date]))
Fair enough. One more trick. Instead of adding an implicit measure, add and explicit measure and correct for isblank:
Can you please explain. How can i do it with YTD measure? YTD of 20 January should show the F value 30 not 0.
Just wrap it around the main expression:
YTD = TOTALYTD(
IF(ISBLANK(SUM('Sheet1'[Value]),0,SUM(Sheet2[Value]))
,'Sheet1'[Date].[Date]
,'Sheet1'[Date]<= SELECTEDVALUE(Sheet1[Date])
)
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |