Forum Discussion

ES335Cherry's avatar
ES335Cherry
Frequent Visitor
1 year ago
Solved

Measure is returning BLANK

Ultimately, I am wanting AVERAGE sum of win per month divided by average number of open tables per month I have a T-SQL routine that works swimmingly where I figure the average win MTD by summing fo...
blank
DAX
measure
  • FBergamaschi's avatar
    FBergamaschi
    1 year ago

    Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.

     

    Need help uploading data? click here

     

    Want faster answers? click here

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi  ES335Cherry ,
Thank you for the prompt response  FBergamaschi !
We totally understand and appreciate the data sensitivity. If possible, even a mocked-up version with fake numbers (but same structure) would help us understand the layout and relationships. 
Please provide sample data that covers your issue or question  in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Thank you.

Regards,
pallavi.