Forum Discussion

ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
4 years ago

Need help on DAX function with measure vs column

Hello, Lastest_WorkDate = CALCULATE(MAX(LEM_FACTS[WORKDATE]))-this is measure column NO_OF_DAYS_Running Behind = DATEDIFF(LEM_FACTS[Lastest_WorkDate],TODAY(),DAY)-this is measure column Lev...
Need Help
SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

I need more info.

Pay attenation that the solution was for a calculated column. Check that the result is correct in the data tab view. You showes a screenshot of a visual which is an aggregation on top of what we did and it depends on the filter context generated by the visual and also on the summarization of the column ( i see count, maybe you wanted sum)

ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
4 years ago

I would like to count (no of vendor(CNRCNSUM)) who fall under those five categary. Total I have 102 CNRCNSUM. 

This report suppose to show me - each vendor(or contract no) submit their lastest workdate invocie(we call as LEM). So we calculated maximum workdate. then we calculated no of days running behind. and then five categaroy.

For Business summary - I would like to show how many vendor fall under which categary. 

Would you help me please

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

    I'm sorry

    I need to see exactly the data, it's already deviated a lot from what I thought was the question. PM me if you want

    vojtechsima any ideas on what is missing from our replies so far?

    • ABC11's avatar
      ABC11
      Icon for Resolver I rankResolver I
      4 years ago

      How can I share my data. How/where I can upload my file PBI file

      • vojtechsima's avatar
        vojtechsima
        Icon for Super User rankSuper User
        4 years ago

        ABC11 Hi, 
        you can share your model as Screenshot of Model in Power BI Desktop and sample data by pasting a raw data here in comments like this:

        Data Data2 Something More
        456 KDAa Something Else
        456853 DSA Yes
        913250 KDAa No
        1369647 DSA Something Else
        1826044 KDAa Yes
        2282441 DSA No
        2738838 KDAa Something Else
        3195235 DSA Yes
        3651632 KDAa No
        4108029 DSA Something Else



        Ideally, if you can upload your file to OneDrive (or Google Drive) and share the link, that would be awesome, if you have sensitive data, please re-create your file using random values, keep the structure and model and send it like this.