Forum Discussion

PZUDGW's avatar
PZUDGW
Icon for Helper I rankHelper I
4 years ago

Help 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 -- -- z...
Help with DAX
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

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.

PZUDGW's avatar
PZUDGW
Icon for Helper I rankHelper I
4 years ago

tamerj1 

That's right. All the columns are in the same table. When I try to filter all blank Cancelationreasons, the PBI-table is not showing the data right (all reasons showing the same numbers). When I remove the command to filter the blanks, the PBI-table suddenly shows the right data (but including all blanks).

 

Using CROSSFILTER didn't do the trick..

Any other suggestions?

 

Greez Api

 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    PZUDGW 
    Try this

    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] ),
        ALLNOBLANKROW ( factMRCUSTDEBTSETTLEMENT[SGCUCDEBTSETTVERDCANCELREASON] ),
        YEAR ( factMRCUSTDEBTSETTLEMENT[DATEEVACUATIONPLANNED] ) = vJaar,
        USERELATIONSHIP ( _Calender[Date], factMRCUSTDEBTSETTLEMENT[DATEEVACUATIONPLANNED] )
    )