Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Formulate the Following as a Measure

Hi Experts

 

I just did the following Steps.

I selected a Product ID72201092 from my table  went to View on tool bar selected Performance Analyzer > Start Recording > Selected the Products Complaints Totals with Trend Direct Table

 

Then Select copy Visual, this gave me the DAX code which allows me to cross filter. how can i convert this to a working measure that i can add into my power bi report.

 

DEFINE =
VAR __DS0FilterTable = TREATAS({"Y"}, 'PMS_FINANCIAL_PDS'[ROLL12_COMPLETE_PDS_IND])

VAR __ValueFilterDM0 = FILTER(
KEEPFILTERS(
SUMMARIZECOLUMNS(
'PMS_PARTS'[Product],
__DS0FilterTable,
"p_value", '_Measures'[p-value],
"v__trend", '_Measures'[__trend],
"ArrowY", 'URLImages'[ArrowY],
"Significance_Y", '_Measures'[Significance Y],
"TAU", 'PMS_FINANCIAL_PDS'[TAU],
"NoTrend_Significants", '_TrendsTable'[NoTrend_Significants]
)
),
[NoTrend_Significants] > 0
)

VAR __DS0Core = 
SUMMARIZECOLUMNS(
'PMS_PARTS'[Product],
__DS0FilterTable,
__ValueFilterDM0,
"p_value", '_Measures'[p-value],
"v__trend", '_Measures'[__trend],
"ArrowY", 'URLImages'[ArrowY],
"Significance_Y", '_Measures'[Significance Y],
"TAU", 'PMS_FINANCIAL_PDS'[TAU],
"NoTrend_Significants", '_TrendsTable'[NoTrend_Significants]
)

EVALUATE
GROUPBY(
__DS0Core,
"MinNoTrend_Significants", MINX(CURRENTGROUP(), [NoTrend_Significants]),
"MaxNoTrend_Significants", MAXX(CURRENTGROUP(), [NoTrend_Significants])
)

EVALUATE
TOPN(501, __DS0Core, 'PMS_PARTS'[Product], 1)

ORDER BY
'PMS_PARTS'[Product]
  • Hi Anonymous ,

     

    I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

     

    Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

1 Reply

  • v-xicai's avatar
    v-xicai
    Community Support

    Hi Anonymous ,

     

    I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

     

    Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.