Forum Discussion
Helper IHelp with Dax-measure
Dear,
When I use the DAX-quary as shown down below, I do not get the aspected result.
Aantal geannuleerde ontruimingen =
-- aantal geannuleerde ontruimingen in de geselecteerde periode --
-- zijn wel gepland, maar er is een reden voor annulering opgegeven --
VAR vJaar = SELECTEDVALUE(_Calender[Year])
RETURN
CALCULATE(
DISTINCTCOUNT(factMRCUSTDEBTSETTLEMENT[DEBTSETTLEMENTID]),
factMRCUSTDEBTSETTLEMENT[SGCUCDEBTSETTVERDCANCELREASON] <> BLANK(),
YEAR(factMRCUSTDEBTSETTLEMENT[DATEEVACUATIONPLANNED])=vJaar,
USERELATIONSHIP(_Calender[Date],factMRCUSTDEBTSETTLEMENT[DATEEVACUATIONPLANNED])
)Result:
All the fields are in the same table (factMRCUSTDEBTSETTLEMENT). In this measure I need to remove all
6 Replies
- Greg_Deckler
Community Champion
PZUDGW Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. 
PZUDGWKlopt (tabel factMRCUSTDEBTSETTLEMENT). Daarom vind ik het ook zo vreemd dat dan de weergave verstoord wordt. Wanneer ik de regel voor het verwijderen van de lege regels verwijder, worden de aantallen wel netjes per maand getoond. Daarom heb ik het vermoeden dat het in de regel voor de blanks zit..
- tamerj1
PZUDGW
I understand that the fact table has two relationships with the Date table. One is active and the other is inactive. And you are using USERELATIONSHIP to activate the inactive one.
It happened with me once and I could not find the answer but you may also deactivate the active relationship using CROSFILTER and set the active relationship to "None". It worth nothing to try.
